Dataset statistics
| Number of variables | 46 |
|---|---|
| Number of observations | 144226 |
| Missing cells | 1618253 |
| Missing cells (%) | 24.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 50.6 MiB |
| Average record size in memory | 368.0 B |
Variable types
| Numeric | 11 |
|---|---|
| DateTime | 4 |
| Categorical | 13 |
| Text | 11 |
| Unsupported | 7 |
Complaint Type has constant value "" | Constant |
Descriptor has constant value "" | Constant |
Facility Type has constant value "" | Constant |
BBL is highly overall correlated with Borough and 7 other fields | High correlation |
Borough is highly overall correlated with BBL and 4 other fields | High correlation |
Borough Boundaries is highly overall correlated with BBL and 6 other fields | High correlation |
City is highly overall correlated with BBL and 3 other fields | High correlation |
Latitude is highly overall correlated with BBL and 3 other fields | High correlation |
Longitude is highly overall correlated with Park Borough and 2 other fields | High correlation |
Park Borough is highly overall correlated with BBL and 6 other fields | High correlation |
Police Precincts is highly overall correlated with BBL and 4 other fields | High correlation |
Resolution Description is highly overall correlated with Status | High correlation |
Status is highly overall correlated with Resolution Description | High correlation |
X Coordinate (State Plane) is highly overall correlated with Longitude and 1 other fields | High correlation |
Y Coordinate (State Plane) is highly overall correlated with BBL and 2 other fields | High correlation |
incident_zip is highly overall correlated with BBL and 4 other fields | High correlation |
zip_codes is highly overall correlated with incident_zip | High correlation |
Agency is highly imbalanced (> 99.9%) | Imbalance |
agency_name is highly imbalanced (> 99.9%) | Imbalance |
location_type is highly imbalanced (89.9%) | Imbalance |
Address Type is highly imbalanced (75.2%) | Imbalance |
closed_date has 77444 (53.7%) missing values | Missing |
location_type has 10523 (7.3%) missing values | Missing |
Incident Address has 2601 (1.8%) missing values | Missing |
Street Name has 2601 (1.8%) missing values | Missing |
Cross Street 1 has 16781 (11.6%) missing values | Missing |
Cross Street 2 has 15910 (11.0%) missing values | Missing |
Intersection Street 1 has 53208 (36.9%) missing values | Missing |
Intersection Street 2 has 52337 (36.3%) missing values | Missing |
Address Type has 15612 (10.8%) missing values | Missing |
City has 2297 (1.6%) missing values | Missing |
Landmark has 68746 (47.7%) missing values | Missing |
Facility Type has 144225 (> 99.9%) missing values | Missing |
Due Date has 78009 (54.1%) missing values | Missing |
Resolution Description has 10930 (7.6%) missing values | Missing |
Resolution Action Updated Date has 14307 (9.9%) missing values | Missing |
BBL has 21174 (14.7%) missing values | Missing |
X Coordinate (State Plane) has 2022 (1.4%) missing values | Missing |
Y Coordinate (State Plane) has 2016 (1.4%) missing values | Missing |
Vehicle Type has 144226 (100.0%) missing values | Missing |
Taxi Company Borough has 144226 (100.0%) missing values | Missing |
Taxi Pick Up Location has 144226 (100.0%) missing values | Missing |
Bridge Highway Name has 144226 (100.0%) missing values | Missing |
Bridge Highway Direction has 144226 (100.0%) missing values | Missing |
Road Ramp has 144226 (100.0%) missing values | Missing |
Bridge Highway Segment has 144226 (100.0%) missing values | Missing |
Latitude has 2022 (1.4%) missing values | Missing |
Longitude has 2022 (1.4%) missing values | Missing |
Location has 2022 (1.4%) missing values | Missing |
zip_codes has 2486 (1.7%) missing values | Missing |
Community Districts has 2034 (1.4%) missing values | Missing |
Borough Boundaries has 2034 (1.4%) missing values | Missing |
City Council Districts has 2034 (1.4%) missing values | Missing |
Police Precincts has 2034 (1.4%) missing values | Missing |
Unique Key has unique values | Unique |
Vehicle Type is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Taxi Company Borough is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Taxi Pick Up Location is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Bridge Highway Name is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Bridge Highway Direction is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Road Ramp is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Bridge Highway Segment is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2023-11-28 17:01:28.849506 |
|---|---|
| Analysis finished | 2023-11-28 17:03:49.220983 |
| Duration | 2 minutes and 20.37 seconds |
| Software version | ydata-profiling vv4.6.2 |
| Download configuration | config.json |
Unique Key
Real number (ℝ)
UNIQUE 
| Distinct | 144226 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45637677 |
| Minimum | 32311150 |
|---|---|
| Maximum | 59550214 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 32311150 |
|---|---|
| 5-th percentile | 33396242 |
| Q1 | 38332805 |
| median | 44195880 |
| Q3 | 54081986 |
| 95-th percentile | 58292800 |
| Maximum | 59550214 |
| Range | 27239064 |
| Interquartile range (IQR) | 15749181 |
Descriptive statistics
| Standard deviation | 8469109.6 |
|---|---|
| Coefficient of variation (CV) | 0.18557276 |
| Kurtosis | -1.3853633 |
| Mean | 45637677 |
| Median Absolute Deviation (MAD) | 7657971 |
| Skewness | 0.10098611 |
| Sum | 6.5821396 × 1012 |
| Variance | 7.1725817 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59544918 | 1 | < 0.1% |
| 39915803 | 1 | < 0.1% |
| 39912840 | 1 | < 0.1% |
| 39912577 | 1 | < 0.1% |
| 39916765 | 1 | < 0.1% |
| 39911868 | 1 | < 0.1% |
| 39915845 | 1 | < 0.1% |
| 39911614 | 1 | < 0.1% |
| 39917908 | 1 | < 0.1% |
| 39913824 | 1 | < 0.1% |
| Other values (144216) | 144216 |
| Value | Count | Frequency (%) |
| 32311150 | 1 | |
| 32311162 | 1 | |
| 32311873 | 1 | |
| 32311944 | 1 | |
| 32312384 | 1 | |
| 32312385 | 1 | |
| 32312409 | 1 | |
| 32312809 | 1 | |
| 32314333 | 1 | |
| 32314570 | 1 |
| Value | Count | Frequency (%) |
| 59550214 | 1 | |
| 59550213 | 1 | |
| 59549163 | 1 | |
| 59549162 | 1 | |
| 59549161 | 1 | |
| 59548103 | 1 | |
| 59548102 | 1 | |
| 59548101 | 1 | |
| 59545988 | 1 | |
| 59545987 | 1 |
created_date
Date
| Distinct | 135253 |
|---|---|
| Distinct (%) | 93.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2016-01-01 09:35:43 |
|---|---|
| Maximum | 2023-11-25 20:28:12 |
closed_date
Date
MISSING 
| Distinct | 51583 |
|---|---|
| Distinct (%) | 77.2% |
| Missing | 77444 |
| Missing (%) | 53.7% |
| Memory size | 1.1 MiB |
| Minimum | 1899-12-31 19:00:00 |
|---|---|
| Maximum | 2023-11-22 14:54:59 |
Agency
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| DPR | |
|---|---|
| NYPD | 1 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0000069 |
| Min length | 3 |
Characters and Unicode
| Total characters | 432679 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | DPR |
|---|---|
| 2nd row | DPR |
| 3rd row | DPR |
| 4th row | DPR |
| 5th row | DPR |
Common Values
| Value | Count | Frequency (%) |
| DPR | 144225 | |
| NYPD | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| dpr | 144225 | |
| nypd | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 144226 | |
| P | 144226 | |
| R | 144225 | |
| N | 1 | < 0.1% |
| Y | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 432679 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 144226 | |
| P | 144226 | |
| R | 144225 | |
| N | 1 | < 0.1% |
| Y | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 432679 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 144226 | |
| P | 144226 | |
| R | 144225 | |
| N | 1 | < 0.1% |
| Y | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 432679 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 144226 | |
| P | 144226 | |
| R | 144225 | |
| N | 1 | < 0.1% |
| Y | 1 | < 0.1% |
agency_name
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Department of Parks and Recreation | |
|---|---|
| New York City Police Department | 1 |
Length
| Max length | 34 |
|---|---|
| Median length | 34 |
| Mean length | 33.999979 |
| Min length | 31 |
Characters and Unicode
| Total characters | 4903681 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Department of Parks and Recreation |
|---|---|
| 2nd row | Department of Parks and Recreation |
| 3rd row | Department of Parks and Recreation |
| 4th row | Department of Parks and Recreation |
| 5th row | Department of Parks and Recreation |
Common Values
| Value | Count | Frequency (%) |
| Department of Parks and Recreation | 144225 | |
| New York City Police Department | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| department | 144226 | |
| of | 144225 | |
| parks | 144225 | |
| and | 144225 | |
| recreation | 144225 | |
| new | 1 | < 0.1% |
| york | 1 | < 0.1% |
| city | 1 | < 0.1% |
| police | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 576904 | ||
| e | 576904 | |
| a | 576901 | |
| t | 432678 | 8.8% |
| r | 432677 | 8.8% |
| n | 432676 | 8.8% |
| o | 288452 | 5.9% |
| i | 144227 | 2.9% |
| D | 144226 | 2.9% |
| P | 144226 | 2.9% |
| Other values (14) | 1153810 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3894097 | |
| Space Separator | 576904 | 11.8% |
| Uppercase Letter | 432680 | 8.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 576904 | |
| a | 576901 | |
| t | 432678 | |
| r | 432677 | |
| n | 432676 | |
| o | 288452 | |
| i | 144227 | 3.7% |
| c | 144226 | 3.7% |
| k | 144226 | 3.7% |
| m | 144226 | 3.7% |
| Other values (7) | 576904 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 144226 | |
| P | 144226 | |
| R | 144225 | |
| N | 1 | < 0.1% |
| Y | 1 | < 0.1% |
| C | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 576904 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4326777 | |
| Common | 576904 | 11.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 576904 | |
| a | 576901 | |
| t | 432678 | |
| r | 432677 | |
| n | 432676 | |
| o | 288452 | 6.7% |
| i | 144227 | 3.3% |
| D | 144226 | 3.3% |
| P | 144226 | 3.3% |
| c | 144226 | 3.3% |
| Other values (13) | 1009584 |
Common
| Value | Count | Frequency (%) |
| 576904 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4903681 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 576904 | ||
| e | 576904 | |
| a | 576901 | |
| t | 432678 | 8.8% |
| r | 432677 | 8.8% |
| n | 432676 | 8.8% |
| o | 288452 | 5.9% |
| i | 144227 | 2.9% |
| D | 144226 | 2.9% |
| P | 144226 | 2.9% |
| Other values (14) | 1153810 |
Complaint Type
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| New Tree Request |
|---|
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Characters and Unicode
| Total characters | 2307616 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New Tree Request |
|---|---|
| 2nd row | New Tree Request |
| 3rd row | New Tree Request |
| 4th row | New Tree Request |
| 5th row | New Tree Request |
Common Values
| Value | Count | Frequency (%) |
| New Tree Request | 144226 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| new | 144226 | |
| tree | 144226 | |
| request | 144226 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 721130 | |
| 288452 | 12.5% | |
| N | 144226 | 6.2% |
| w | 144226 | 6.2% |
| T | 144226 | 6.2% |
| r | 144226 | 6.2% |
| R | 144226 | 6.2% |
| q | 144226 | 6.2% |
| u | 144226 | 6.2% |
| s | 144226 | 6.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1586486 | |
| Uppercase Letter | 432678 | 18.8% |
| Space Separator | 288452 | 12.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 721130 | |
| w | 144226 | 9.1% |
| r | 144226 | 9.1% |
| q | 144226 | 9.1% |
| u | 144226 | 9.1% |
| s | 144226 | 9.1% |
| t | 144226 | 9.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 144226 | |
| T | 144226 | |
| R | 144226 |
Space Separator
| Value | Count | Frequency (%) |
| 288452 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2019164 | |
| Common | 288452 | 12.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 721130 | |
| N | 144226 | 7.1% |
| w | 144226 | 7.1% |
| T | 144226 | 7.1% |
| r | 144226 | 7.1% |
| R | 144226 | 7.1% |
| q | 144226 | 7.1% |
| u | 144226 | 7.1% |
| s | 144226 | 7.1% |
| t | 144226 | 7.1% |
Common
| Value | Count | Frequency (%) |
| 288452 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2307616 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 721130 | |
| 288452 | 12.5% | |
| N | 144226 | 6.2% |
| w | 144226 | 6.2% |
| T | 144226 | 6.2% |
| r | 144226 | 6.2% |
| R | 144226 | 6.2% |
| q | 144226 | 6.2% |
| u | 144226 | 6.2% |
| s | 144226 | 6.2% |
Descriptor
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| For One Address |
|---|
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Characters and Unicode
| Total characters | 2163390 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | For One Address |
|---|---|
| 2nd row | For One Address |
| 3rd row | For One Address |
| 4th row | For One Address |
| 5th row | For One Address |
Common Values
| Value | Count | Frequency (%) |
| For One Address | 144226 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| for | 144226 | |
| one | 144226 | |
| address | 144226 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 288452 | |
| 288452 | ||
| e | 288452 | |
| d | 288452 | |
| s | 288452 | |
| F | 144226 | |
| o | 144226 | |
| O | 144226 | |
| n | 144226 | |
| A | 144226 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1442260 | |
| Uppercase Letter | 432678 | 20.0% |
| Space Separator | 288452 | 13.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 288452 | |
| e | 288452 | |
| d | 288452 | |
| s | 288452 | |
| o | 144226 | |
| n | 144226 |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 144226 | |
| O | 144226 | |
| A | 144226 |
Space Separator
| Value | Count | Frequency (%) |
| 288452 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1874938 | |
| Common | 288452 | 13.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 288452 | |
| e | 288452 | |
| d | 288452 | |
| s | 288452 | |
| F | 144226 | |
| o | 144226 | |
| O | 144226 | |
| n | 144226 | |
| A | 144226 |
Common
| Value | Count | Frequency (%) |
| 288452 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2163390 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 288452 | |
| 288452 | ||
| e | 288452 | |
| d | 288452 | |
| s | 288452 | |
| F | 144226 | |
| o | 144226 | |
| O | 144226 | |
| n | 144226 | |
| A | 144226 |
location_type
Categorical
IMBALANCE  MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10523 |
| Missing (%) | 7.3% |
| Memory size | 1.1 MiB |
| Street | |
|---|---|
| Park | 1568 |
| Street/Curbside | 1101 |
Length
| Max length | 15 |
|---|---|
| Median length | 6 |
| Mean length | 6.0506571 |
| Min length | 4 |
Characters and Unicode
| Total characters | 808991 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Street |
|---|---|
| 2nd row | Street |
| 3rd row | Street |
| 4th row | Street |
| 5th row | Street |
Common Values
| Value | Count | Frequency (%) |
| Street | 131034 | |
| Park | 1568 | 1.1% |
| Street/Curbside | 1101 | 0.8% |
| (Missing) | 10523 | 7.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| street | 131034 | |
| park | 1568 | 1.2% |
| street/curbside | 1101 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 265371 | |
| t | 264270 | |
| r | 134804 | |
| S | 132135 | |
| P | 1568 | 0.2% |
| a | 1568 | 0.2% |
| k | 1568 | 0.2% |
| / | 1101 | 0.1% |
| C | 1101 | 0.1% |
| u | 1101 | 0.1% |
| Other values (4) | 4404 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 673086 | |
| Uppercase Letter | 134804 | 16.7% |
| Other Punctuation | 1101 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 265371 | |
| t | 264270 | |
| r | 134804 | |
| a | 1568 | 0.2% |
| k | 1568 | 0.2% |
| u | 1101 | 0.2% |
| b | 1101 | 0.2% |
| s | 1101 | 0.2% |
| i | 1101 | 0.2% |
| d | 1101 | 0.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 132135 | |
| P | 1568 | 1.2% |
| C | 1101 | 0.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 1101 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 807890 | |
| Common | 1101 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 265371 | |
| t | 264270 | |
| r | 134804 | |
| S | 132135 | |
| P | 1568 | 0.2% |
| a | 1568 | 0.2% |
| k | 1568 | 0.2% |
| C | 1101 | 0.1% |
| u | 1101 | 0.1% |
| b | 1101 | 0.1% |
| Other values (3) | 3303 | 0.4% |
Common
| Value | Count | Frequency (%) |
| / | 1101 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 808991 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 265371 | |
| t | 264270 | |
| r | 134804 | |
| S | 132135 | |
| P | 1568 | 0.2% |
| a | 1568 | 0.2% |
| k | 1568 | 0.2% |
| / | 1101 | 0.1% |
| C | 1101 | 0.1% |
| u | 1101 | 0.1% |
| Other values (4) | 4404 | 0.5% |
incident_zip
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 205 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1240 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10877.806 |
| Minimum | 83 |
|---|---|
| Maximum | 12345 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 83 |
|---|---|
| 5-th percentile | 10012 |
| Q1 | 10308 |
| median | 11215 |
| Q3 | 11235 |
| 95-th percentile | 11418 |
| Maximum | 12345 |
| Range | 12262 |
| Interquartile range (IQR) | 927 |
Descriptive statistics
| Standard deviation | 547.32809 |
|---|---|
| Coefficient of variation (CV) | 0.050316036 |
| Kurtosis | 0.73882802 |
| Mean | 10877.806 |
| Median Absolute Deviation (MAD) | 158 |
| Skewness | -0.71616596 |
| Sum | 1.555374 × 109 |
| Variance | 299568.03 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11229 | 5274 | 3.7% |
| 11235 | 4419 | 3.1% |
| 11215 | 3913 | 2.7% |
| 11385 | 3586 | 2.5% |
| 11238 | 2668 | 1.8% |
| 10467 | 2648 | 1.8% |
| 11230 | 2417 | 1.7% |
| 10021 | 1956 | 1.4% |
| 10312 | 1931 | 1.3% |
| 11218 | 1846 | 1.3% |
| Other values (195) | 112328 |
| Value | Count | Frequency (%) |
| 83 | 2 | < 0.1% |
| 10000 | 1 | < 0.1% |
| 10001 | 512 | 0.4% |
| 10002 | 887 | |
| 10003 | 1731 | |
| 10004 | 23 | < 0.1% |
| 10005 | 31 | < 0.1% |
| 10006 | 61 | < 0.1% |
| 10007 | 142 | 0.1% |
| 10009 | 1238 |
| Value | Count | Frequency (%) |
| 12345 | 1 | < 0.1% |
| 11697 | 10 | < 0.1% |
| 11695 | 1 | < 0.1% |
| 11694 | 1024 | |
| 11693 | 237 | 0.2% |
| 11692 | 89 | 0.1% |
| 11691 | 309 | 0.2% |
| 11436 | 248 | 0.2% |
| 11435 | 406 | 0.3% |
| 11434 | 358 | 0.2% |
Incident Address
Text
MISSING 
| Distinct | 91627 |
|---|---|
| Distinct (%) | 64.7% |
| Missing | 2601 |
| Missing (%) | 1.8% |
| Memory size | 1.1 MiB |
Length
| Max length | 64 |
|---|---|
| Median length | 59 |
| Mean length | 17.733515 |
| Min length | 2 |
Characters and Unicode
| Total characters | 2511509 |
|---|---|
| Distinct characters | 67 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 67046 ? |
|---|---|
| Unique (%) | 47.3% |
Sample
| 1st row | 1907 1 AVENUE |
|---|---|
| 2nd row | 526 WEST 146 STREET |
| 3rd row | 2252 1 AVENUE |
| 4th row | 2252 1 AVENUE |
| 5th row | 250 UNION AVENUE |
| Value | Count | Frequency (%) |
| street | 69627 | 15.1% |
| avenue | 46825 | 10.1% |
| east | 19114 | 4.1% |
| west | 10235 | 2.2% |
| road | 5823 | 1.3% |
| boulevard | 5578 | 1.2% |
| place | 4689 | 1.0% |
| st | 2064 | 0.4% |
| park | 1548 | 0.3% |
| parkway | 1494 | 0.3% |
| Other values (18636) | 295245 |
Most occurring characters
| Value | Count | Frequency (%) |
| 350414 | ||
| E | 331669 | 13.2% |
| T | 208880 | 8.3% |
| A | 134853 | 5.4% |
| R | 134252 | 5.3% |
| S | 130487 | 5.2% |
| 1 | 117112 | 4.7% |
| N | 99658 | 4.0% |
| 2 | 83287 | 3.3% |
| 3 | 67681 | 2.7% |
| Other values (57) | 853216 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1516055 | |
| Decimal Number | 612465 | |
| Space Separator | 350414 | 14.0% |
| Dash Punctuation | 30805 | 1.2% |
| Lowercase Letter | 1651 | 0.1% |
| Other Punctuation | 119 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 331669 | |
| T | 208880 | |
| A | 134853 | |
| R | 134252 | |
| S | 130487 | 8.6% |
| N | 99658 | 6.6% |
| U | 64904 | 4.3% |
| V | 60019 | 4.0% |
| O | 57404 | 3.8% |
| L | 41856 | 2.8% |
| Other values (16) | 252073 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 218 | |
| r | 204 | |
| e | 159 | |
| o | 130 | 7.9% |
| n | 130 | 7.9% |
| l | 105 | 6.4% |
| s | 93 | 5.6% |
| i | 88 | 5.3% |
| k | 85 | 5.1% |
| t | 69 | 4.2% |
| Other values (15) | 370 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 117112 | |
| 2 | 83287 | |
| 3 | 67681 | |
| 0 | 57008 | |
| 5 | 56735 | |
| 4 | 56073 | |
| 6 | 46873 | |
| 7 | 45400 | 7.4% |
| 8 | 44744 | 7.3% |
| 9 | 37552 | 6.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 80 | |
| / | 19 | 16.0% |
| . | 19 | 16.0% |
| & | 1 | 0.8% |
Space Separator
| Value | Count | Frequency (%) |
| 350414 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 30805 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1517706 | |
| Common | 993803 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 331669 | |
| T | 208880 | |
| A | 134853 | |
| R | 134252 | |
| S | 130487 | 8.6% |
| N | 99658 | 6.6% |
| U | 64904 | 4.3% |
| V | 60019 | 4.0% |
| O | 57404 | 3.8% |
| L | 41856 | 2.8% |
| Other values (41) | 253724 |
Common
| Value | Count | Frequency (%) |
| 350414 | ||
| 1 | 117112 | 11.8% |
| 2 | 83287 | 8.4% |
| 3 | 67681 | 6.8% |
| 0 | 57008 | 5.7% |
| 5 | 56735 | 5.7% |
| 4 | 56073 | 5.6% |
| 6 | 46873 | 4.7% |
| 7 | 45400 | 4.6% |
| 8 | 44744 | 4.5% |
| Other values (6) | 68476 | 6.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2511509 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 350414 | ||
| E | 331669 | 13.2% |
| T | 208880 | 8.3% |
| A | 134853 | 5.4% |
| R | 134252 | 5.3% |
| S | 130487 | 5.2% |
| 1 | 117112 | 4.7% |
| N | 99658 | 4.0% |
| 2 | 83287 | 3.3% |
| 3 | 67681 | 2.7% |
| Other values (57) | 853216 |
Street Name
Text
MISSING 
| Distinct | 7366 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 2601 |
| Missing (%) | 1.8% |
| Memory size | 1.1 MiB |
Length
| Max length | 42 |
|---|---|
| Median length | 31 |
| Mean length | 13.123269 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1858583 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1893 ? |
|---|---|
| Unique (%) | 1.3% |
Sample
| 1st row | 1 AVENUE |
|---|---|
| 2nd row | WEST 146 STREET |
| 3rd row | 1 AVENUE |
| 4th row | 1 AVENUE |
| 5th row | UNION AVENUE |
| Value | Count | Frequency (%) |
| street | 69627 | |
| avenue | 46825 | 14.5% |
| east | 19110 | 5.9% |
| west | 10235 | 3.2% |
| road | 5823 | 1.8% |
| boulevard | 5578 | 1.7% |
| place | 4689 | 1.5% |
| st | 2060 | 0.6% |
| parkway | 1494 | 0.5% |
| park | 1468 | 0.5% |
| Other values (3528) | 155157 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 331637 | |
| 210238 | ||
| T | 208861 | |
| A | 134369 | 7.2% |
| R | 134245 | 7.2% |
| S | 130471 | 7.0% |
| N | 99654 | 5.4% |
| U | 64904 | 3.5% |
| V | 60015 | 3.2% |
| O | 57402 | 3.1% |
| Other values (30) | 426787 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1515098 | |
| Space Separator | 210238 | 11.3% |
| Decimal Number | 133156 | 7.2% |
| Other Punctuation | 86 | < 0.1% |
| Dash Punctuation | 5 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 331637 | |
| T | 208861 | |
| A | 134369 | |
| R | 134245 | |
| S | 130471 | 8.6% |
| N | 99654 | 6.6% |
| U | 64904 | 4.3% |
| V | 60015 | 4.0% |
| O | 57402 | 3.8% |
| L | 41846 | 2.8% |
| Other values (16) | 251694 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 28446 | |
| 2 | 18420 | |
| 3 | 13355 | |
| 7 | 12512 | |
| 4 | 11726 | |
| 8 | 11491 | |
| 5 | 10890 | 8.2% |
| 6 | 10161 | 7.6% |
| 9 | 9396 | 7.1% |
| 0 | 6759 | 5.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 80 | |
| . | 6 | 7.0% |
Space Separator
| Value | Count | Frequency (%) |
| 210238 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1515098 | |
| Common | 343485 | 18.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 331637 | |
| T | 208861 | |
| A | 134369 | |
| R | 134245 | |
| S | 130471 | 8.6% |
| N | 99654 | 6.6% |
| U | 64904 | 4.3% |
| V | 60015 | 4.0% |
| O | 57402 | 3.8% |
| L | 41846 | 2.8% |
| Other values (16) | 251694 |
Common
| Value | Count | Frequency (%) |
| 210238 | ||
| 1 | 28446 | 8.3% |
| 2 | 18420 | 5.4% |
| 3 | 13355 | 3.9% |
| 7 | 12512 | 3.6% |
| 4 | 11726 | 3.4% |
| 8 | 11491 | 3.3% |
| 5 | 10890 | 3.2% |
| 6 | 10161 | 3.0% |
| 9 | 9396 | 2.7% |
| Other values (4) | 6850 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1858583 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 331637 | |
| 210238 | ||
| T | 208861 | |
| A | 134369 | 7.2% |
| R | 134245 | 7.2% |
| S | 130471 | 7.0% |
| N | 99654 | 5.4% |
| U | 64904 | 3.5% |
| V | 60015 | 3.2% |
| O | 57402 | 3.1% |
| Other values (30) | 426787 |
Cross Street 1
Text
MISSING 
| Distinct | 6340 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 16781 |
| Missing (%) | 11.6% |
| Memory size | 1.1 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 12.602205 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1606088 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1386 ? |
|---|---|
| Unique (%) | 1.1% |
Sample
| 1st row | EAST 97 STREET |
|---|---|
| 2nd row | AMSTERDAM AVENUE |
| 3rd row | EAST 115 STREET |
| 4th row | EAST 115 STREET |
| 5th row | MESEROLE STREET |
| Value | Count | Frequency (%) |
| avenue | 62819 | |
| street | 40254 | 14.2% |
| east | 10596 | 3.7% |
| west | 6166 | 2.2% |
| road | 5391 | 1.9% |
| place | 4309 | 1.5% |
| boulevard | 3725 | 1.3% |
| 5 | 2301 | 0.8% |
| 3 | 2116 | 0.7% |
| 2 | 1685 | 0.6% |
| Other values (3806) | 143208 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 289129 | |
| 173121 | ||
| A | 138478 | 8.6% |
| T | 130195 | 8.1% |
| N | 112448 | 7.0% |
| R | 98390 | 6.1% |
| S | 85888 | 5.3% |
| U | 79894 | 5.0% |
| V | 73327 | 4.6% |
| O | 51315 | 3.2% |
| Other values (32) | 373903 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1329281 | |
| Space Separator | 173121 | 10.8% |
| Decimal Number | 103435 | 6.4% |
| Dash Punctuation | 171 | < 0.1% |
| Other Punctuation | 80 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 289129 | |
| A | 138478 | |
| T | 130195 | |
| N | 112448 | 8.5% |
| R | 98390 | 7.4% |
| S | 85888 | 6.5% |
| U | 79894 | 6.0% |
| V | 73327 | 5.5% |
| O | 51315 | 3.9% |
| L | 39383 | 3.0% |
| Other values (16) | 230834 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 22683 | |
| 2 | 13253 | |
| 3 | 10894 | |
| 5 | 9635 | |
| 8 | 9050 | 8.7% |
| 4 | 8732 | 8.4% |
| 6 | 8286 | 8.0% |
| 7 | 7881 | 7.6% |
| 9 | 6620 | 6.4% |
| 0 | 6401 | 6.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 46 | |
| / | 28 | |
| & | 5 | 6.2% |
| . | 1 | 1.2% |
Space Separator
| Value | Count | Frequency (%) |
| 173121 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 171 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1329281 | |
| Common | 276807 | 17.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 289129 | |
| A | 138478 | |
| T | 130195 | |
| N | 112448 | 8.5% |
| R | 98390 | 7.4% |
| S | 85888 | 6.5% |
| U | 79894 | 6.0% |
| V | 73327 | 5.5% |
| O | 51315 | 3.9% |
| L | 39383 | 3.0% |
| Other values (16) | 230834 |
Common
| Value | Count | Frequency (%) |
| 173121 | ||
| 1 | 22683 | 8.2% |
| 2 | 13253 | 4.8% |
| 3 | 10894 | 3.9% |
| 5 | 9635 | 3.5% |
| 8 | 9050 | 3.3% |
| 4 | 8732 | 3.2% |
| 6 | 8286 | 3.0% |
| 7 | 7881 | 2.8% |
| 9 | 6620 | 2.4% |
| Other values (6) | 6652 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1606088 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 289129 | |
| 173121 | ||
| A | 138478 | 8.6% |
| T | 130195 | 8.1% |
| N | 112448 | 7.0% |
| R | 98390 | 6.1% |
| S | 85888 | 5.3% |
| U | 79894 | 5.0% |
| V | 73327 | 4.6% |
| O | 51315 | 3.2% |
| Other values (32) | 373903 |
Cross Street 2
Text
MISSING 
| Distinct | 6423 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 15910 |
| Missing (%) | 11.0% |
| Memory size | 1.1 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 12.748636 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1635854 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1418 ? |
|---|---|
| Unique (%) | 1.1% |
Sample
| 1st row | EAST 99 STREET |
|---|---|
| 2nd row | BROADWAY |
| 3rd row | EAST 116 STREET |
| 4th row | EAST 116 STREET |
| 5th row | SCHOLES STREET |
| Value | Count | Frequency (%) |
| avenue | 62508 | |
| street | 41344 | 14.4% |
| east | 11889 | 4.1% |
| west | 6074 | 2.1% |
| road | 4891 | 1.7% |
| place | 4444 | 1.5% |
| boulevard | 3719 | 1.3% |
| 3 | 1546 | 0.5% |
| drive | 1520 | 0.5% |
| 1 | 1492 | 0.5% |
| Other values (3835) | 147433 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 294192 | |
| 177891 | ||
| A | 139272 | 8.5% |
| T | 134679 | 8.2% |
| N | 111684 | 6.8% |
| R | 102324 | 6.3% |
| S | 88330 | 5.4% |
| U | 79508 | 4.9% |
| V | 74391 | 4.5% |
| O | 52288 | 3.2% |
| Other values (33) | 381295 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1350960 | |
| Space Separator | 177891 | 10.9% |
| Decimal Number | 106762 | 6.5% |
| Dash Punctuation | 124 | < 0.1% |
| Other Punctuation | 115 | < 0.1% |
| Open Punctuation | 1 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 294192 | |
| A | 139272 | |
| T | 134679 | |
| N | 111684 | 8.3% |
| R | 102324 | 7.6% |
| S | 88330 | 6.5% |
| U | 79508 | 5.9% |
| V | 74391 | 5.5% |
| O | 52288 | 3.9% |
| L | 39105 | 2.9% |
| Other values (16) | 235187 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 23883 | |
| 2 | 17127 | |
| 3 | 10546 | |
| 4 | 8650 | 8.1% |
| 8 | 8522 | 8.0% |
| 6 | 8474 | 7.9% |
| 5 | 8304 | 7.8% |
| 7 | 8214 | 7.7% |
| 9 | 6790 | 6.4% |
| 0 | 6252 | 5.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 83 | |
| ' | 30 | 26.1% |
| & | 2 | 1.7% |
Space Separator
| Value | Count | Frequency (%) |
| 177891 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 124 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1350960 | |
| Common | 284894 | 17.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 294192 | |
| A | 139272 | |
| T | 134679 | |
| N | 111684 | 8.3% |
| R | 102324 | 7.6% |
| S | 88330 | 6.5% |
| U | 79508 | 5.9% |
| V | 74391 | 5.5% |
| O | 52288 | 3.9% |
| L | 39105 | 2.9% |
| Other values (16) | 235187 |
Common
| Value | Count | Frequency (%) |
| 177891 | ||
| 1 | 23883 | 8.4% |
| 2 | 17127 | 6.0% |
| 3 | 10546 | 3.7% |
| 4 | 8650 | 3.0% |
| 8 | 8522 | 3.0% |
| 6 | 8474 | 3.0% |
| 5 | 8304 | 2.9% |
| 7 | 8214 | 2.9% |
| 9 | 6790 | 2.4% |
| Other values (7) | 6493 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1635854 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 294192 | |
| 177891 | ||
| A | 139272 | 8.5% |
| T | 134679 | 8.2% |
| N | 111684 | 6.8% |
| R | 102324 | 6.3% |
| S | 88330 | 5.4% |
| U | 79508 | 4.9% |
| V | 74391 | 4.5% |
| O | 52288 | 3.2% |
| Other values (33) | 381295 |
MISSING 
| Distinct | 5708 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 53208 |
| Missing (%) | 36.9% |
| Memory size | 1.1 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 12.78034 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1163241 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1406 ? |
|---|---|
| Unique (%) | 1.5% |
Sample
| 1st row | EAST 97 STREET |
|---|---|
| 2nd row | AMSTERDAM AVENUE |
| 3rd row | EAST 115 STREET |
| 4th row | EAST 115 STREET |
| 5th row | MESEROLE STREET |
| Value | Count | Frequency (%) |
| avenue | 43808 | |
| street | 29516 | 14.5% |
| east | 7243 | 3.6% |
| west | 4990 | 2.5% |
| road | 3869 | 1.9% |
| place | 3122 | 1.5% |
| boulevard | 2515 | 1.2% |
| 5 | 1623 | 0.8% |
| 3 | 1525 | 0.8% |
| 2 | 1184 | 0.6% |
| Other values (3581) | 103712 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 206990 | |
| 130390 | ||
| A | 98847 | 8.5% |
| T | 95800 | 8.2% |
| N | 80370 | 6.9% |
| R | 71588 | 6.2% |
| S | 62978 | 5.4% |
| U | 56126 | 4.8% |
| V | 51120 | 4.4% |
| O | 37469 | 3.2% |
| Other values (31) | 271563 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 958826 | |
| Space Separator | 130390 | 11.2% |
| Decimal Number | 73789 | 6.3% |
| Dash Punctuation | 169 | < 0.1% |
| Other Punctuation | 67 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 206990 | |
| A | 98847 | |
| T | 95800 | |
| N | 80370 | 8.4% |
| R | 71588 | 7.5% |
| S | 62978 | 6.6% |
| U | 56126 | 5.9% |
| V | 51120 | 5.3% |
| O | 37469 | 3.9% |
| L | 28693 | 3.0% |
| Other values (16) | 168845 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 16495 | |
| 2 | 9716 | |
| 3 | 7626 | |
| 5 | 6853 | |
| 8 | 6458 | 8.8% |
| 4 | 6317 | 8.6% |
| 6 | 5790 | 7.8% |
| 7 | 5341 | 7.2% |
| 0 | 4638 | 6.3% |
| 9 | 4555 | 6.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 37 | |
| / | 25 | |
| & | 5 | 7.5% |
Space Separator
| Value | Count | Frequency (%) |
| 130390 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 169 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 958826 | |
| Common | 204415 | 17.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 206990 | |
| A | 98847 | |
| T | 95800 | |
| N | 80370 | 8.4% |
| R | 71588 | 7.5% |
| S | 62978 | 6.6% |
| U | 56126 | 5.9% |
| V | 51120 | 5.3% |
| O | 37469 | 3.9% |
| L | 28693 | 3.0% |
| Other values (16) | 168845 |
Common
| Value | Count | Frequency (%) |
| 130390 | ||
| 1 | 16495 | 8.1% |
| 2 | 9716 | 4.8% |
| 3 | 7626 | 3.7% |
| 5 | 6853 | 3.4% |
| 8 | 6458 | 3.2% |
| 4 | 6317 | 3.1% |
| 6 | 5790 | 2.8% |
| 7 | 5341 | 2.6% |
| 0 | 4638 | 2.3% |
| Other values (5) | 4791 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1163241 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 206990 | |
| 130390 | ||
| A | 98847 | 8.5% |
| T | 95800 | 8.2% |
| N | 80370 | 6.9% |
| R | 71588 | 6.2% |
| S | 62978 | 5.4% |
| U | 56126 | 4.8% |
| V | 51120 | 4.4% |
| O | 37469 | 3.2% |
| Other values (31) | 271563 |
MISSING 
| Distinct | 5823 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 52337 |
| Missing (%) | 36.3% |
| Memory size | 1.1 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 12.982381 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1192938 |
|---|---|
| Distinct characters | 44 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1489 ? |
|---|---|
| Unique (%) | 1.6% |
Sample
| 1st row | EAST 99 STREET |
|---|---|
| 2nd row | BROADWAY |
| 3rd row | EAST 116 STREET |
| 4th row | EAST 116 STREET |
| 5th row | SCHOLES STREET |
| Value | Count | Frequency (%) |
| avenue | 43764 | |
| street | 30367 | 14.7% |
| east | 8306 | 4.0% |
| west | 4921 | 2.4% |
| road | 3406 | 1.6% |
| place | 3214 | 1.6% |
| boulevard | 2679 | 1.3% |
| 222 | 1283 | 0.6% |
| drive | 1159 | 0.6% |
| beach | 1073 | 0.5% |
| Other values (3621) | 106853 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 212274 | |
| 134650 | ||
| A | 100350 | 8.4% |
| T | 99295 | 8.3% |
| N | 80006 | 6.7% |
| R | 75618 | 6.3% |
| S | 64943 | 5.4% |
| U | 56148 | 4.7% |
| V | 52415 | 4.4% |
| O | 37887 | 3.2% |
| Other values (34) | 279352 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 981452 | |
| Space Separator | 134650 | 11.3% |
| Decimal Number | 76601 | 6.4% |
| Dash Punctuation | 123 | < 0.1% |
| Other Punctuation | 110 | < 0.1% |
| Open Punctuation | 1 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 212274 | |
| A | 100350 | |
| T | 99295 | |
| N | 80006 | 8.2% |
| R | 75618 | 7.7% |
| S | 64943 | 6.6% |
| U | 56148 | 5.7% |
| V | 52415 | 5.3% |
| O | 37887 | 3.9% |
| L | 28935 | 2.9% |
| Other values (16) | 173581 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 17131 | |
| 2 | 13431 | |
| 3 | 7380 | |
| 4 | 6227 | 8.1% |
| 6 | 5986 | 7.8% |
| 5 | 5965 | 7.8% |
| 8 | 5921 | 7.7% |
| 7 | 5574 | 7.3% |
| 9 | 4676 | 6.1% |
| 0 | 4310 | 5.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 81 | |
| ' | 26 | 23.6% |
| & | 2 | 1.8% |
| . | 1 | 0.9% |
Space Separator
| Value | Count | Frequency (%) |
| 134650 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 123 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 981452 | |
| Common | 211486 | 17.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 212274 | |
| A | 100350 | |
| T | 99295 | |
| N | 80006 | 8.2% |
| R | 75618 | 7.7% |
| S | 64943 | 6.6% |
| U | 56148 | 5.7% |
| V | 52415 | 5.3% |
| O | 37887 | 3.9% |
| L | 28935 | 2.9% |
| Other values (16) | 173581 |
Common
| Value | Count | Frequency (%) |
| 134650 | ||
| 1 | 17131 | 8.1% |
| 2 | 13431 | 6.4% |
| 3 | 7380 | 3.5% |
| 4 | 6227 | 2.9% |
| 6 | 5986 | 2.8% |
| 5 | 5965 | 2.8% |
| 8 | 5921 | 2.8% |
| 7 | 5574 | 2.6% |
| 9 | 4676 | 2.2% |
| Other values (8) | 4545 | 2.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1192938 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 212274 | |
| 134650 | ||
| A | 100350 | 8.4% |
| T | 99295 | 8.3% |
| N | 80006 | 6.7% |
| R | 75618 | 6.3% |
| S | 64943 | 5.4% |
| U | 56148 | 4.7% |
| V | 52415 | 4.4% |
| O | 37887 | 3.2% |
| Other values (34) | 279352 |
Address Type
Categorical
IMBALANCE  MISSING 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 15612 |
| Missing (%) | 10.8% |
| Memory size | 1.1 MiB |
| ADDRESS | |
|---|---|
| LATLONG | |
| INTERSECTION | 1723 |
| BLOCKFACE | 517 |
| UNRECOGNIZED | 236 |
Length
| Max length | 12 |
|---|---|
| Median length | 7 |
| Mean length | 7.0842132 |
| Min length | 7 |
Characters and Unicode
| Total characters | 911129 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ADDRESS |
|---|---|
| 2nd row | ADDRESS |
| 3rd row | ADDRESS |
| 4th row | ADDRESS |
| 5th row | ADDRESS |
Common Values
| Value | Count | Frequency (%) |
| ADDRESS | 112640 | |
| LATLONG | 13497 | 9.4% |
| INTERSECTION | 1723 | 1.2% |
| BLOCKFACE | 517 | 0.4% |
| UNRECOGNIZED | 236 | 0.2% |
| PLACENAME | 1 | < 0.1% |
| (Missing) | 15612 | 10.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| address | 112640 | |
| latlong | 13497 | 10.5% |
| intersection | 1723 | 1.3% |
| blockface | 517 | 0.4% |
| unrecognized | 236 | 0.2% |
| placename | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 227003 | |
| D | 225516 | |
| A | 126656 | |
| E | 117077 | |
| R | 114599 | |
| L | 27512 | 3.0% |
| N | 17416 | 1.9% |
| T | 16943 | 1.9% |
| O | 15973 | 1.8% |
| G | 13733 | 1.5% |
| Other values (9) | 8701 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 911129 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 227003 | |
| D | 225516 | |
| A | 126656 | |
| E | 117077 | |
| R | 114599 | |
| L | 27512 | 3.0% |
| N | 17416 | 1.9% |
| T | 16943 | 1.9% |
| O | 15973 | 1.8% |
| G | 13733 | 1.5% |
| Other values (9) | 8701 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 911129 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 227003 | |
| D | 225516 | |
| A | 126656 | |
| E | 117077 | |
| R | 114599 | |
| L | 27512 | 3.0% |
| N | 17416 | 1.9% |
| T | 16943 | 1.9% |
| O | 15973 | 1.8% |
| G | 13733 | 1.5% |
| Other values (9) | 8701 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 911129 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 227003 | |
| D | 225516 | |
| A | 126656 | |
| E | 117077 | |
| R | 114599 | |
| L | 27512 | 3.0% |
| N | 17416 | 1.9% |
| T | 16943 | 1.9% |
| O | 15973 | 1.8% |
| G | 13733 | 1.5% |
| Other values (9) | 8701 | 1.0% |
City
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 50 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2297 |
| Missing (%) | 1.6% |
| Memory size | 1.1 MiB |
| BROOKLYN | |
|---|---|
| NEW YORK | |
| BRONX | |
| STATEN ISLAND | |
| RIDGEWOOD | 3566 |
| Other values (45) |
Length
| Max length | 19 |
|---|---|
| Median length | 8 |
| Mean length | 8.6705043 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1230596 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NEW YORK |
|---|---|
| 2nd row | NEW YORK |
| 3rd row | NEW YORK |
| 4th row | NEW YORK |
| 5th row | BROOKLYN |
Common Values
| Value | Count | Frequency (%) |
| BROOKLYN | 56534 | |
| NEW YORK | 30173 | |
| BRONX | 11611 | 8.1% |
| STATEN ISLAND | 9720 | 6.7% |
| RIDGEWOOD | 3566 | 2.5% |
| ASTORIA | 2607 | 1.8% |
| FLUSHING | 2420 | 1.7% |
| JAMAICA | 2013 | 1.4% |
| JACKSON HEIGHTS | 1382 | 1.0% |
| HOWARD BEACH | 1349 | 0.9% |
| Other values (40) | 20554 | 14.3% |
| (Missing) | 2297 | 1.6% |
Length
| Value | Count | Frequency (%) |
| brooklyn | 56534 | |
| new | 30221 | |
| york | 30173 | |
| bronx | 11611 | 5.8% |
| island | 10465 | 5.2% |
| staten | 9720 | 4.9% |
| ridgewood | 3566 | 1.8% |
| astoria | 2607 | 1.3% |
| flushing | 2420 | 1.2% |
| park | 2244 | 1.1% |
| Other values (52) | 40063 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 184625 | |
| N | 134104 | |
| R | 120468 | |
| K | 94127 | 7.6% |
| Y | 90649 | 7.4% |
| L | 86846 | 7.1% |
| B | 71726 | 5.8% |
| E | 69050 | 5.6% |
| 57695 | 4.7% | |
| A | 53477 | 4.3% |
| Other values (24) | 267829 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1172891 | |
| Space Separator | 57695 | 4.7% |
| Lowercase Letter | 10 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 184625 | |
| N | 134104 | |
| R | 120468 | |
| K | 94127 | |
| Y | 90649 | |
| L | 86846 | 7.4% |
| B | 71726 | 6.1% |
| E | 69050 | 5.9% |
| A | 53477 | 4.6% |
| S | 44442 | 3.8% |
| Other values (16) | 223377 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 3 | |
| k | 2 | |
| o | 1 | 10.0% |
| c | 1 | 10.0% |
| w | 1 | 10.0% |
| y | 1 | 10.0% |
| r | 1 | 10.0% |
Space Separator
| Value | Count | Frequency (%) |
| 57695 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1172901 | |
| Common | 57695 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 184625 | |
| N | 134104 | |
| R | 120468 | |
| K | 94127 | |
| Y | 90649 | |
| L | 86846 | 7.4% |
| B | 71726 | 6.1% |
| E | 69050 | 5.9% |
| A | 53477 | 4.6% |
| S | 44442 | 3.8% |
| Other values (23) | 223387 |
Common
| Value | Count | Frequency (%) |
| 57695 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1230596 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 184625 | |
| N | 134104 | |
| R | 120468 | |
| K | 94127 | 7.6% |
| Y | 90649 | 7.4% |
| L | 86846 | 7.1% |
| B | 71726 | 5.8% |
| E | 69050 | 5.6% |
| 57695 | 4.7% | |
| A | 53477 | 4.3% |
| Other values (24) | 267829 |
Landmark
Text
MISSING 
| Distinct | 4402 |
|---|---|
| Distinct (%) | 5.8% |
| Missing | 68746 |
| Missing (%) | 47.7% |
| Memory size | 1.1 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.32651 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1005885 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1003 ? |
|---|---|
| Unique (%) | 1.3% |
Sample
| 1st row | 1 AVENUE |
|---|---|
| 2nd row | WEST 146 STREET |
| 3rd row | 1 AVENUE |
| 4th row | 1 AVENUE |
| 5th row | UNION AVENUE |
| Value | Count | Frequency (%) |
| street | 36865 | |
| avenue | 25436 | 14.8% |
| east | 9285 | 5.4% |
| west | 5957 | 3.5% |
| boulevard | 3491 | 2.0% |
| road | 3414 | 2.0% |
| place | 2405 | 1.4% |
| bronx | 1406 | 0.8% |
| 3 | 912 | 0.5% |
| parkway | 879 | 0.5% |
| Other values (2754) | 81736 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 176976 | |
| 126849 | ||
| T | 108105 | |
| R | 72303 | 7.2% |
| A | 71914 | 7.1% |
| S | 67760 | 6.7% |
| N | 54180 | 5.4% |
| U | 35407 | 3.5% |
| V | 32596 | 3.2% |
| O | 32132 | 3.2% |
| Other values (31) | 227663 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 808021 | |
| Space Separator | 126849 | 12.6% |
| Decimal Number | 71004 | 7.1% |
| Other Punctuation | 8 | < 0.1% |
| Dash Punctuation | 3 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 176976 | |
| T | 108105 | |
| R | 72303 | |
| A | 71914 | |
| S | 67760 | 8.4% |
| N | 54180 | 6.7% |
| U | 35407 | 4.4% |
| V | 32596 | 4.0% |
| O | 32132 | 4.0% |
| L | 22744 | 2.8% |
| Other values (16) | 133904 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 15219 | |
| 2 | 9594 | |
| 3 | 7051 | |
| 7 | 6563 | |
| 5 | 6391 | |
| 4 | 6235 | |
| 8 | 6073 | 8.6% |
| 6 | 5389 | 7.6% |
| 9 | 4892 | 6.9% |
| 0 | 3597 | 5.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 4 | |
| & | 3 | |
| / | 1 | 12.5% |
Space Separator
| Value | Count | Frequency (%) |
| 126849 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 808021 | |
| Common | 197864 | 19.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 176976 | |
| T | 108105 | |
| R | 72303 | |
| A | 71914 | |
| S | 67760 | 8.4% |
| N | 54180 | 6.7% |
| U | 35407 | 4.4% |
| V | 32596 | 4.0% |
| O | 32132 | 4.0% |
| L | 22744 | 2.8% |
| Other values (16) | 133904 |
Common
| Value | Count | Frequency (%) |
| 126849 | ||
| 1 | 15219 | 7.7% |
| 2 | 9594 | 4.8% |
| 3 | 7051 | 3.6% |
| 7 | 6563 | 3.3% |
| 5 | 6391 | 3.2% |
| 4 | 6235 | 3.2% |
| 8 | 6073 | 3.1% |
| 6 | 5389 | 2.7% |
| 9 | 4892 | 2.5% |
| Other values (5) | 3608 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1005885 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 176976 | |
| 126849 | ||
| T | 108105 | |
| R | 72303 | 7.2% |
| A | 71914 | 7.1% |
| S | 67760 | 6.7% |
| N | 54180 | 5.4% |
| U | 35407 | 3.5% |
| V | 32596 | 3.2% |
| O | 32132 | 3.2% |
| Other values (31) | 227663 |
Facility Type
Text
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 144225 |
| Missing (%) | > 99.9% |
| Memory size | 1.1 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 8 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Precinct |
|---|
| Value | Count | Frequency (%) |
| precinct | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 2 | |
| P | 1 | |
| r | 1 | |
| e | 1 | |
| i | 1 | |
| n | 1 | |
| t | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7 | |
| Uppercase Letter | 1 | 12.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 2 | |
| r | 1 | |
| e | 1 | |
| i | 1 | |
| n | 1 | |
| t | 1 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| c | 2 | |
| P | 1 | |
| r | 1 | |
| e | 1 | |
| i | 1 | |
| n | 1 | |
| t | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| c | 2 | |
| P | 1 | |
| r | 1 | |
| e | 1 | |
| i | 1 | |
| n | 1 | |
| t | 1 |
Status
Categorical
HIGH CORRELATION 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Closed | |
|---|---|
| In Progress | |
| Assigned | |
| Open | 6057 |
| Unspecified | 10 |
| Other values (2) | 3 |
Length
| Max length | 16 |
|---|---|
| Median length | 11 |
| Mean length | 8.0841735 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1165948 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | In Progress |
|---|---|
| 2nd row | In Progress |
| 3rd row | In Progress |
| 4th row | In Progress |
| 5th row | In Progress |
Common Values
| Value | Count | Frequency (%) |
| Closed | 66553 | |
| In Progress | 56477 | |
| Assigned | 15126 | 10.5% |
| Open | 6057 | 4.2% |
| Unspecified | 10 | < 0.1% |
| Closed - Testing | 2 | < 0.1% |
| Draft | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| closed | 66555 | |
| in | 56477 | |
| progress | 56477 | |
| assigned | 15126 | 7.5% |
| open | 6057 | 3.0% |
| unspecified | 10 | < 0.1% |
| 2 | < 0.1% | |
| testing | 2 | < 0.1% |
| draft | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 209773 | |
| e | 144237 | |
| o | 123032 | |
| r | 112955 | |
| d | 81691 | 7.0% |
| n | 77672 | 6.7% |
| g | 71605 | 6.1% |
| C | 66555 | 5.7% |
| l | 66555 | 5.7% |
| 56481 | 4.8% | |
| Other values (14) | 155392 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 908760 | |
| Uppercase Letter | 200705 | 17.2% |
| Space Separator | 56481 | 4.8% |
| Dash Punctuation | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 209773 | |
| e | 144237 | |
| o | 123032 | |
| r | 112955 | |
| d | 81691 | 9.0% |
| n | 77672 | 8.5% |
| g | 71605 | 7.9% |
| l | 66555 | 7.3% |
| i | 15148 | 1.7% |
| p | 6067 | 0.7% |
| Other values (4) | 25 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 66555 | |
| I | 56477 | |
| P | 56477 | |
| A | 15126 | 7.5% |
| O | 6057 | 3.0% |
| U | 10 | < 0.1% |
| T | 2 | < 0.1% |
| D | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 56481 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1109465 | |
| Common | 56483 | 4.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 209773 | |
| e | 144237 | |
| o | 123032 | |
| r | 112955 | |
| d | 81691 | 7.4% |
| n | 77672 | 7.0% |
| g | 71605 | 6.5% |
| C | 66555 | 6.0% |
| l | 66555 | 6.0% |
| I | 56477 | 5.1% |
| Other values (12) | 98913 |
Common
| Value | Count | Frequency (%) |
| 56481 | ||
| - | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1165948 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 209773 | |
| e | 144237 | |
| o | 123032 | |
| r | 112955 | |
| d | 81691 | 7.0% |
| n | 77672 | 6.7% |
| g | 71605 | 6.1% |
| C | 66555 | 5.7% |
| l | 66555 | 5.7% |
| 56481 | 4.8% | |
| Other values (14) | 155392 |
Due Date
Date
MISSING 
| Distinct | 65216 |
|---|---|
| Distinct (%) | 98.5% |
| Missing | 78009 |
| Missing (%) | 54.1% |
| Memory size | 1.1 MiB |
| Minimum | 2016-06-29 09:35:43 |
|---|---|
| Maximum | 2021-06-17 19:02:46 |
Resolution Description
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 47 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10930 |
| Missing (%) | 7.6% |
| Memory size | 1.1 MiB |
| The Department of Parks and Recreation has reviewed this request and will visit the location to investigate the condition. | |
|---|---|
| The Department of Parks and Recreation has determined that the requested location cannot receive a new tree because of conflicts with surrounding infrastructure. | |
| NYC Parks will inspect the site to determine if it is suitable for a new street tree, including a review of potential conflicts with other infrastructure. If the site is found to be suitable, a tree will be planted during the next available planting season. You may review recently completed and upcoming street tree plantings in your neighborhood by visiting the NYC Parks Tree Work Hub at nyc.gov/parks/treework. | |
| NYC Parks determined that the requested location cannot receive a new tree because of conflicts with surrounding infrastructure. | |
| NYC Parks reviewed this request and will visit the location to investigate the condition. Under NYC Parks’ Tree Risk Management Program, all trees under the agency's jurisdiction are assessed for risk, and work is prioritized to address the conditions with the highest risk first. For more information about the Tree Risk Management Program, visit the NYC Urban Forest page on the NYC Parks website at nyc.gov/parks/trees. To learn more about the trees in your neighborhood, visit the NYC Tree Map at nyc.gov/parks/treemap. | |
| Other values (42) |
Length
| Max length | 529 |
|---|---|
| Median length | 287 |
| Mean length | 270.94182 |
| Min length | 63 |
Characters and Unicode
| Total characters | 36115461 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NYC Parks determined that the requested location cannot receive a new tree because of conflicts with surrounding infrastructure. |
|---|---|
| 2nd row | NYC Parks visited the location but could not find the tree condition you reported. |
| 3rd row | NYC Parks determined that the requested location cannot receive a new tree because of conflicts with surrounding infrastructure. |
| 4th row | The location was inspected and is suitable for tree planting. Barring any unforeseen issues such as underground utilities and based on available funding, the requested tree will be placed on an upcoming contract. Please note that this process can take up to two years, depending on capacity and the location. To find out where and when trees will be planted, please visit the Tree Work Hub at nyc.gov/parks/treework. To learn more about the trees in your neighborhood, visit the NYC Street Tree Map at nyc.gov/parks/treemap. |
| 5th row | The location was inspected and is suitable for tree planting. Barring any unforeseen issues such as underground utilities and based on available funding, the requested tree will be placed on an upcoming contract. Please note that this process can take up to two years, depending on capacity and the location. To find out where and when trees will be planted, please visit the Tree Work Hub at nyc.gov/parks/treework. To learn more about the trees in your neighborhood, visit the NYC Street Tree Map at nyc.gov/parks/treemap. |
Common Values
| Value | Count | Frequency (%) |
| The Department of Parks and Recreation has reviewed this request and will visit the location to investigate the condition. | 20049 | |
| The Department of Parks and Recreation has determined that the requested location cannot receive a new tree because of conflicts with surrounding infrastructure. | 19825 | |
| NYC Parks will inspect the site to determine if it is suitable for a new street tree, including a review of potential conflicts with other infrastructure. If the site is found to be suitable, a tree will be planted during the next available planting season. You may review recently completed and upcoming street tree plantings in your neighborhood by visiting the NYC Parks Tree Work Hub at nyc.gov/parks/treework. | 19296 | |
| NYC Parks determined that the requested location cannot receive a new tree because of conflicts with surrounding infrastructure. | 18435 | |
| NYC Parks reviewed this request and will visit the location to investigate the condition. Under NYC Parks’ Tree Risk Management Program, all trees under the agency's jurisdiction are assessed for risk, and work is prioritized to address the conditions with the highest risk first. For more information about the Tree Risk Management Program, visit the NYC Urban Forest page on the NYC Parks website at nyc.gov/parks/trees. To learn more about the trees in your neighborhood, visit the NYC Tree Map at nyc.gov/parks/treemap. | 17131 | |
| The location was inspected and is suitable for tree planting. Barring any unforeseen issues such as underground utilities and based on available funding, the requested tree will be placed on an upcoming contract. Please note that this process can take up to two years, depending on capacity and the location. To find out where and when trees will be planted, please visit the Tree Work Hub at nyc.gov/parks/treework. To learn more about the trees in your neighborhood, visit the NYC Street Tree Map at nyc.gov/parks/treemap. | 10177 | |
| The Department of Parks and Recreation will review your request within one year. It may take up to 24 months to inspect the location for planting. To learn more about the street tree planting process, visit www.nyc.gov/parks. Please note your Service Request number for future reference. | 6030 | 4.2% |
| The Department of Parks and Recreation has planted the tree(s). | 4195 | 2.9% |
| The Service Request submitted did not have sufficient location or complaint information for NYC Parks to respond. Please submit a new Service Request with adequate site details, including a full street address and descriptive location information. | 3004 | 2.1% |
| The location has been inspected and is scheduled for planting during the spring planting season. The spring planting season runs from approximately March to May, weather permitting. | 2746 | 1.9% |
| Other values (37) | 12408 | |
| (Missing) | 10930 |
Length
| Value | Count | Frequency (%) |
| the | 496683 | 8.8% |
| tree | 216275 | 3.8% |
| and | 180957 | 3.2% |
| to | 170724 | 3.0% |
| nyc | 160151 | 2.8% |
| parks | 154361 | 2.7% |
| location | 120302 | 2.1% |
| of | 118315 | 2.1% |
| a | 110086 | 2.0% |
| will | 102314 | 1.8% |
| Other values (210) | 3808139 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5613282 | ||
| e | 3972441 | 11.0% |
| t | 3014787 | 8.3% |
| i | 2295515 | 6.4% |
| r | 2278440 | 6.3% |
| n | 2186126 | 6.1% |
| a | 2135010 | 5.9% |
| o | 1918190 | 5.3% |
| s | 1785385 | 4.9% |
| c | 944675 | 2.6% |
| Other values (47) | 9971610 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 28350150 | |
| Space Separator | 5613282 | 15.5% |
| Uppercase Letter | 1376088 | 3.8% |
| Other Punctuation | 721125 | 2.0% |
| Control | 34262 | 0.1% |
| Decimal Number | 12164 | < 0.1% |
| Open Punctuation | 4195 | < 0.1% |
| Close Punctuation | 4195 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 3972441 | |
| t | 3014787 | |
| i | 2295515 | 8.1% |
| r | 2278440 | 8.0% |
| n | 2186126 | 7.7% |
| a | 2135010 | 7.5% |
| o | 1918190 | 6.8% |
| s | 1785385 | 6.3% |
| c | 944675 | 3.3% |
| h | 942582 | 3.3% |
| Other values (17) | 6876999 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 229354 | |
| T | 216378 | |
| Y | 179476 | |
| N | 164649 | |
| C | 160173 | |
| R | 107507 | |
| M | 67064 | 4.9% |
| D | 58338 | 4.2% |
| U | 34262 | 2.5% |
| F | 34262 | 2.5% |
| Other values (8) | 124625 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 384993 | |
| , | 165095 | |
| / | 153854 | 21.3% |
| ' | 17183 | 2.4% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 6030 | |
| 4 | 6030 | |
| 5 | 104 | 0.9% |
Control
| Value | Count | Frequency (%) |
| ™ | 17131 | |
| € | 17131 |
Space Separator
| Value | Count | Frequency (%) |
| 5613282 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 4195 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 4195 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 29726238 | |
| Common | 6389223 | 17.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 3972441 | |
| t | 3014787 | 10.1% |
| i | 2295515 | 7.7% |
| r | 2278440 | 7.7% |
| n | 2186126 | 7.4% |
| a | 2135010 | 7.2% |
| o | 1918190 | 6.5% |
| s | 1785385 | 6.0% |
| c | 944675 | 3.2% |
| h | 942582 | 3.2% |
| Other values (35) | 8253087 |
Common
| Value | Count | Frequency (%) |
| 5613282 | ||
| . | 384993 | 6.0% |
| , | 165095 | 2.6% |
| / | 153854 | 2.4% |
| ' | 17183 | 0.3% |
| ™ | 17131 | 0.3% |
| € | 17131 | 0.3% |
| 2 | 6030 | 0.1% |
| 4 | 6030 | 0.1% |
| ( | 4195 | 0.1% |
| Other values (2) | 4299 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 36064068 | |
| None | 51393 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5613282 | ||
| e | 3972441 | |
| t | 3014787 | 8.4% |
| i | 2295515 | 6.4% |
| r | 2278440 | 6.3% |
| n | 2186126 | 6.1% |
| a | 2135010 | 5.9% |
| o | 1918190 | 5.3% |
| s | 1785385 | 5.0% |
| c | 944675 | 2.6% |
| Other values (44) | 9920217 |
None
| Value | Count | Frequency (%) |
| ™ | 17131 | |
| € | 17131 | |
| â | 17131 |
Resolution Action Updated Date
Date
MISSING 
| Distinct | 93787 |
|---|---|
| Distinct (%) | 72.2% |
| Missing | 14307 |
| Missing (%) | 9.9% |
| Memory size | 1.1 MiB |
| Minimum | 2016-01-04 08:03:06 |
|---|---|
| Maximum | 2023-11-22 14:55:05 |
Community Board
Text
| Distinct | 74 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 21 |
| Mean length | 10.862431 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1566645 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 11 MANHATTAN |
|---|---|
| 2nd row | 09 MANHATTAN |
| 3rd row | 11 MANHATTAN |
| 4th row | 11 MANHATTAN |
| 5th row | 01 BROOKLYN |
| Value | Count | Frequency (%) |
| brooklyn | 56851 | |
| queens | 34189 | 11.5% |
| manhattan | 30375 | 10.2% |
| 01 | 14646 | 4.9% |
| 03 | 13647 | 4.6% |
| bronx | 11786 | 4.0% |
| 08 | 11503 | 3.9% |
| 02 | 11213 | 3.8% |
| 12 | 10720 | 3.6% |
| 06 | 9885 | 3.3% |
| Other values (25) | 93407 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 183116 | 11.7% |
| 153996 | 9.8% | |
| O | 125488 | 8.0% |
| A | 110665 | 7.1% |
| 0 | 103095 | 6.6% |
| T | 80290 | 5.1% |
| E | 78148 | 5.0% |
| 1 | 71160 | 4.5% |
| B | 68637 | 4.4% |
| R | 68637 | 4.4% |
| Other values (27) | 523413 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1110982 | |
| Decimal Number | 286717 | 18.3% |
| Space Separator | 153996 | 9.8% |
| Lowercase Letter | 14950 | 1.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 183116 | |
| O | 125488 | |
| A | 110665 | |
| T | 80290 | 7.2% |
| E | 78148 | 7.0% |
| B | 68637 | 6.2% |
| R | 68637 | 6.2% |
| L | 66621 | 6.0% |
| K | 56851 | 5.1% |
| Y | 56851 | 5.1% |
| Other values (8) | 215678 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 103095 | |
| 1 | 71160 | |
| 2 | 21948 | 7.7% |
| 3 | 17703 | 6.2% |
| 5 | 16593 | 5.8% |
| 8 | 14196 | 5.0% |
| 4 | 13309 | 4.6% |
| 7 | 11161 | 3.9% |
| 6 | 10429 | 3.6% |
| 9 | 7123 | 2.5% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2990 | |
| i | 2990 | |
| n | 1495 | |
| s | 1495 | |
| p | 1495 | |
| c | 1495 | |
| f | 1495 | |
| d | 1495 |
Space Separator
| Value | Count | Frequency (%) |
| 153996 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1125932 | |
| Common | 440713 | 28.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 183116 | |
| O | 125488 | |
| A | 110665 | |
| T | 80290 | 7.1% |
| E | 78148 | 6.9% |
| B | 68637 | 6.1% |
| R | 68637 | 6.1% |
| L | 66621 | 5.9% |
| K | 56851 | 5.0% |
| Y | 56851 | 5.0% |
| Other values (16) | 230628 |
Common
| Value | Count | Frequency (%) |
| 153996 | ||
| 0 | 103095 | |
| 1 | 71160 | |
| 2 | 21948 | 5.0% |
| 3 | 17703 | 4.0% |
| 5 | 16593 | 3.8% |
| 8 | 14196 | 3.2% |
| 4 | 13309 | 3.0% |
| 7 | 11161 | 2.5% |
| 6 | 10429 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1566645 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 183116 | 11.7% |
| 153996 | 9.8% | |
| O | 125488 | 8.0% |
| A | 110665 | 7.1% |
| 0 | 103095 | 6.6% |
| T | 80290 | 5.1% |
| E | 78148 | 5.0% |
| 1 | 71160 | 4.5% |
| B | 68637 | 4.4% |
| R | 68637 | 4.4% |
| Other values (27) | 523413 |
BBL
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 70703 |
|---|---|
| Distinct (%) | 57.5% |
| Missing | 21174 |
| Missing (%) | 14.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9183194 × 109 |
| Minimum | 0 |
|---|---|
| Maximum | 5.20045 × 109 |
| Zeros | 58 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.0071 × 109 |
| Q1 | 2.0407775 × 109 |
| median | 3.05083 × 109 |
| Q3 | 4.02729 × 109 |
| 95-th percentile | 5.01715 × 109 |
| Maximum | 5.20045 × 109 |
| Range | 5.20045 × 109 |
| Interquartile range (IQR) | 1.9865125 × 109 |
Descriptive statistics
| Standard deviation | 1.2168899 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.41698312 |
| Kurtosis | -0.83784517 |
| Mean | 2.9183194 × 109 |
| Median Absolute Deviation (MAD) | 9.8728001 × 108 |
| Skewness | -0.27922614 |
| Sum | 3.5910504 × 1014 |
| Variance | 1.4808211 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2046530041 | 965 | 0.7% |
| 2046530048 | 162 | 0.1% |
| 3019020001 | 120 | 0.1% |
| 2046530090 | 105 | 0.1% |
| 2024930001 | 88 | 0.1% |
| 2046450006 | 87 | 0.1% |
| 2046660049 | 86 | 0.1% |
| 1009720001 | 82 | 0.1% |
| 1011040031 | 82 | 0.1% |
| 3019440004 | 80 | 0.1% |
| Other values (70693) | 121195 | |
| (Missing) | 21174 | 14.7% |
| Value | Count | Frequency (%) |
| 0 | 58 | |
| 1000010010 | 1 | < 0.1% |
| 1000030001 | 2 | < 0.1% |
| 1000057501 | 1 | < 0.1% |
| 1000100023 | 1 | < 0.1% |
| 1000130027 | 1 | < 0.1% |
| 1000150022 | 1 | < 0.1% |
| 1000157501 | 1 | < 0.1% |
| 1000160001 | 2 | < 0.1% |
| 1000160100 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5200449999 | 1 | < 0.1% |
| 5200399999 | 1 | < 0.1% |
| 5200379999 | 1 | < 0.1% |
| 5200169999 | 1 | < 0.1% |
| 5200059999 | 1 | < 0.1% |
| 5200029999 | 1 | < 0.1% |
| 5200009999 | 1 | < 0.1% |
| 5080500058 | 1 | < 0.1% |
| 5080500004 | 1 | < 0.1% |
| 5080490055 | 4 |
Borough
Categorical
HIGH CORRELATION 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| BROOKLYN | |
|---|---|
| QUEENS | |
| MANHATTAN | |
| BRONX | |
| STATEN ISLAND |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 7.857966 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1133323 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MANHATTAN |
|---|---|
| 2nd row | MANHATTAN |
| 3rd row | MANHATTAN |
| 4th row | MANHATTAN |
| 5th row | BROOKLYN |
Common Values
| Value | Count | Frequency (%) |
| BROOKLYN | 56851 | |
| QUEENS | 34186 | |
| MANHATTAN | 30441 | |
| BRONX | 11723 | 8.1% |
| STATEN ISLAND | 9770 | 6.8% |
| Unspecified | 1255 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| brooklyn | 56851 | |
| queens | 34186 | |
| manhattan | 30441 | |
| bronx | 11723 | 7.6% |
| staten | 9770 | 6.3% |
| island | 9770 | 6.3% |
| unspecified | 1255 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 183182 | |
| O | 125425 | |
| A | 110863 | |
| T | 80422 | 7.1% |
| E | 78142 | 6.9% |
| B | 68574 | 6.1% |
| R | 68574 | 6.1% |
| L | 66621 | 5.9% |
| K | 56851 | 5.0% |
| Y | 56851 | 5.0% |
| Other values (17) | 237818 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1111003 | |
| Lowercase Letter | 12550 | 1.1% |
| Space Separator | 9770 | 0.9% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 183182 | |
| O | 125425 | |
| A | 110863 | |
| T | 80422 | 7.2% |
| E | 78142 | 7.0% |
| B | 68574 | 6.2% |
| R | 68574 | 6.2% |
| L | 66621 | 6.0% |
| K | 56851 | 5.1% |
| Y | 56851 | 5.1% |
| Other values (8) | 215498 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2510 | |
| i | 2510 | |
| n | 1255 | |
| s | 1255 | |
| p | 1255 | |
| c | 1255 | |
| f | 1255 | |
| d | 1255 |
Space Separator
| Value | Count | Frequency (%) |
| 9770 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1123553 | |
| Common | 9770 | 0.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 183182 | |
| O | 125425 | |
| A | 110863 | |
| T | 80422 | 7.2% |
| E | 78142 | 7.0% |
| B | 68574 | 6.1% |
| R | 68574 | 6.1% |
| L | 66621 | 5.9% |
| K | 56851 | 5.1% |
| Y | 56851 | 5.1% |
| Other values (16) | 228048 |
Common
| Value | Count | Frequency (%) |
| 9770 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1133323 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 183182 | |
| O | 125425 | |
| A | 110863 | |
| T | 80422 | 7.1% |
| E | 78142 | 6.9% |
| B | 68574 | 6.1% |
| R | 68574 | 6.1% |
| L | 66621 | 5.9% |
| K | 56851 | 5.0% |
| Y | 56851 | 5.0% |
| Other values (17) | 237818 |
X Coordinate (State Plane)
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 52133 |
|---|---|
| Distinct (%) | 36.7% |
| Missing | 2022 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1001126.4 |
| Minimum | 913390 |
|---|---|
| Maximum | 1067055 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 913390 |
|---|---|
| 5-th percentile | 953635 |
| Q1 | 989685 |
| median | 998246.5 |
| Q3 | 1014110 |
| 95-th percentile | 1043721.8 |
| Maximum | 1067055 |
| Range | 153665 |
| Interquartile range (IQR) | 24425 |
Descriptive statistics
| Standard deviation | 23607.599 |
|---|---|
| Coefficient of variation (CV) | 0.023581036 |
| Kurtosis | 1.3994679 |
| Mean | 1001126.4 |
| Median Absolute Deviation (MAD) | 10645.5 |
| Skewness | -0.23956837 |
| Sum | 1.4236418 × 1011 |
| Variance | 5.5731871 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1021287 | 788 | 0.5% |
| 1018045 | 272 | 0.2% |
| 1021399 | 178 | 0.1% |
| 1021305 | 162 | 0.1% |
| 1021515 | 106 | 0.1% |
| 1020790 | 87 | 0.1% |
| 1004038 | 85 | 0.1% |
| 1022130 | 80 | 0.1% |
| 1021980 | 76 | 0.1% |
| 1018543 | 65 | < 0.1% |
| Other values (52123) | 140305 | |
| (Missing) | 2022 | 1.4% |
| Value | Count | Frequency (%) |
| 913390 | 1 | |
| 913803 | 1 | |
| 913861 | 1 | |
| 913862 | 1 | |
| 913875 | 1 | |
| 913879 | 1 | |
| 914030 | 1 | |
| 914047 | 1 | |
| 914231 | 1 | |
| 914241 | 1 |
| Value | Count | Frequency (%) |
| 1067055 | 1 | |
| 1067013 | 1 | |
| 1066926 | 1 | |
| 1066924 | 1 | |
| 1066922 | 1 | |
| 1066844 | 1 | |
| 1066838 | 1 | |
| 1066837 | 1 | |
| 1066836 | 2 | |
| 1066830 | 2 |
Y Coordinate (State Plane)
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 61903 |
|---|---|
| Distinct (%) | 43.5% |
| Missing | 2016 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 196130.75 |
| Minimum | 121156 |
|---|---|
| Maximum | 271660 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 121156 |
|---|---|
| 5-th percentile | 150148 |
| Q1 | 173256.25 |
| median | 195190.5 |
| Q3 | 216788 |
| 95-th percentile | 251389 |
| Maximum | 271660 |
| Range | 150504 |
| Interquartile range (IQR) | 43531.75 |
Descriptive statistics
| Standard deviation | 30110.027 |
|---|---|
| Coefficient of variation (CV) | 0.15352018 |
| Kurtosis | -0.48655416 |
| Mean | 196130.75 |
| Median Absolute Deviation (MAD) | 21730.5 |
| Skewness | 0.18505747 |
| Sum | 2.7891754 × 1010 |
| Variance | 9.0661376 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 261965 | 787 | 0.5% |
| 246472 | 272 | 0.2% |
| 262236 | 178 | 0.1% |
| 262009 | 162 | 0.1% |
| 261846 | 105 | 0.1% |
| 260124 | 87 | 0.1% |
| 241325 | 83 | 0.1% |
| 261076 | 81 | 0.1% |
| 262965 | 74 | 0.1% |
| 258848 | 65 | < 0.1% |
| Other values (61893) | 140316 | |
| (Missing) | 2016 | 1.4% |
| Value | Count | Frequency (%) |
| 121156 | 2 | |
| 121168 | 1 | < 0.1% |
| 121189 | 1 | < 0.1% |
| 121245 | 1 | < 0.1% |
| 121292 | 1 | < 0.1% |
| 121295 | 3 | |
| 121315 | 1 | < 0.1% |
| 121405 | 1 | < 0.1% |
| 121480 | 1 | < 0.1% |
| 121488 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 271660 | 1 | |
| 271515 | 2 | |
| 271512 | 1 | |
| 271498 | 1 | |
| 271409 | 1 | |
| 271316 | 1 | |
| 271233 | 1 | |
| 271219 | 1 | |
| 271217 | 1 | |
| 271183 | 1 |
Open Data Channel Type
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| UNKNOWN | |
|---|---|
| MOBILE | |
| OTHER | |
| PHONE | |
| ONLINE |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 6.0143594 |
| Min length | 5 |
Characters and Unicode
| Total characters | 867427 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MOBILE |
|---|---|
| 2nd row | UNKNOWN |
| 3rd row | UNKNOWN |
| 4th row | UNKNOWN |
| 5th row | MOBILE |
Common Values
| Value | Count | Frequency (%) |
| UNKNOWN | 53117 | |
| MOBILE | 33208 | |
| OTHER | 25970 | |
| PHONE | 25076 | |
| ONLINE | 6855 | 4.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| unknown | 53117 | |
| mobile | 33208 | |
| other | 25970 | |
| phone | 25076 | |
| online | 6855 | 4.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 198137 | |
| O | 144226 | |
| E | 91109 | |
| U | 53117 | 6.1% |
| K | 53117 | 6.1% |
| W | 53117 | 6.1% |
| H | 51046 | 5.9% |
| I | 40063 | 4.6% |
| L | 40063 | 4.6% |
| M | 33208 | 3.8% |
| Other values (4) | 110224 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 867427 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 198137 | |
| O | 144226 | |
| E | 91109 | |
| U | 53117 | 6.1% |
| K | 53117 | 6.1% |
| W | 53117 | 6.1% |
| H | 51046 | 5.9% |
| I | 40063 | 4.6% |
| L | 40063 | 4.6% |
| M | 33208 | 3.8% |
| Other values (4) | 110224 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 867427 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 198137 | |
| O | 144226 | |
| E | 91109 | |
| U | 53117 | 6.1% |
| K | 53117 | 6.1% |
| W | 53117 | 6.1% |
| H | 51046 | 5.9% |
| I | 40063 | 4.6% |
| L | 40063 | 4.6% |
| M | 33208 | 3.8% |
| Other values (4) | 110224 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 867427 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 198137 | |
| O | 144226 | |
| E | 91109 | |
| U | 53117 | 6.1% |
| K | 53117 | 6.1% |
| W | 53117 | 6.1% |
| H | 51046 | 5.9% |
| I | 40063 | 4.6% |
| L | 40063 | 4.6% |
| M | 33208 | 3.8% |
| Other values (4) | 110224 |
| Distinct | 309 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
Length
| Max length | 49 |
|---|---|
| Median length | 11 |
| Mean length | 11.039244 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1592146 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 183 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Unspecified |
|---|---|
| 2nd row | Unspecified |
| 3rd row | Unspecified |
| 4th row | Unspecified |
| 5th row | Unspecified |
| Value | Count | Frequency (%) |
| unspecified | 143439 | |
| park | 524 | 0.4% |
| playground | 180 | 0.1% |
| bronx | 87 | 0.1% |
| corona | 71 | < 0.1% |
| flushing | 67 | < 0.1% |
| meadows | 67 | < 0.1% |
| ogden | 33 | < 0.1% |
| plimpton | 33 | < 0.1% |
| square | 22 | < 0.1% |
| Other values (439) | 1074 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 287712 | |
| i | 287335 | |
| n | 144394 | |
| d | 143917 | |
| s | 143890 | |
| c | 143568 | |
| p | 143512 | |
| f | 143480 | |
| U | 143449 | |
| r | 1429 | 0.1% |
| Other values (55) | 9460 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1445131 | |
| Uppercase Letter | 145589 | 9.1% |
| Space Separator | 1371 | 0.1% |
| Other Punctuation | 32 | < 0.1% |
| Decimal Number | 15 | < 0.1% |
| Dash Punctuation | 8 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 287712 | |
| i | 287335 | |
| n | 144394 | |
| d | 143917 | |
| s | 143890 | |
| c | 143568 | |
| p | 143512 | |
| f | 143480 | |
| r | 1429 | 0.1% |
| a | 1367 | 0.1% |
| Other values (16) | 4527 | 0.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 143449 | |
| P | 799 | 0.5% |
| B | 215 | 0.1% |
| C | 200 | 0.1% |
| F | 130 | 0.1% |
| M | 128 | 0.1% |
| A | 97 | 0.1% |
| S | 81 | 0.1% |
| H | 57 | < 0.1% |
| G | 56 | < 0.1% |
| Other values (14) | 377 | 0.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 6 | |
| 8 | 3 | |
| 3 | 1 | 6.7% |
| 5 | 1 | 6.7% |
| 7 | 1 | 6.7% |
| 9 | 1 | 6.7% |
| 1 | 1 | 6.7% |
| 6 | 1 | 6.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 26 | |
| & | 2 | 6.2% |
| / | 2 | 6.2% |
| ' | 1 | 3.1% |
| , | 1 | 3.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1371 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1590720 | |
| Common | 1426 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 287712 | |
| i | 287335 | |
| n | 144394 | |
| d | 143917 | |
| s | 143890 | |
| c | 143568 | |
| p | 143512 | |
| f | 143480 | |
| U | 143449 | |
| r | 1429 | 0.1% |
| Other values (40) | 8034 | 0.5% |
Common
| Value | Count | Frequency (%) |
| 1371 | ||
| . | 26 | 1.8% |
| - | 8 | 0.6% |
| 4 | 6 | 0.4% |
| 8 | 3 | 0.2% |
| & | 2 | 0.1% |
| / | 2 | 0.1% |
| 3 | 1 | 0.1% |
| 5 | 1 | 0.1% |
| 7 | 1 | 0.1% |
| Other values (5) | 5 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1592146 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 287712 | |
| i | 287335 | |
| n | 144394 | |
| d | 143917 | |
| s | 143890 | |
| c | 143568 | |
| p | 143512 | |
| f | 143480 | |
| U | 143449 | |
| r | 1429 | 0.1% |
| Other values (55) | 9460 | 0.6% |
Park Borough
Categorical
HIGH CORRELATION 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| BROOKLYN | |
|---|---|
| QUEENS | |
| MANHATTAN | |
| BRONX | |
| STATEN ISLAND |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 7.857966 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1133323 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MANHATTAN |
|---|---|
| 2nd row | MANHATTAN |
| 3rd row | MANHATTAN |
| 4th row | MANHATTAN |
| 5th row | BROOKLYN |
Common Values
| Value | Count | Frequency (%) |
| BROOKLYN | 56851 | |
| QUEENS | 34186 | |
| MANHATTAN | 30441 | |
| BRONX | 11723 | 8.1% |
| STATEN ISLAND | 9770 | 6.8% |
| Unspecified | 1255 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| brooklyn | 56851 | |
| queens | 34186 | |
| manhattan | 30441 | |
| bronx | 11723 | 7.6% |
| staten | 9770 | 6.3% |
| island | 9770 | 6.3% |
| unspecified | 1255 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 183182 | |
| O | 125425 | |
| A | 110863 | |
| T | 80422 | 7.1% |
| E | 78142 | 6.9% |
| B | 68574 | 6.1% |
| R | 68574 | 6.1% |
| L | 66621 | 5.9% |
| K | 56851 | 5.0% |
| Y | 56851 | 5.0% |
| Other values (17) | 237818 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1111003 | |
| Lowercase Letter | 12550 | 1.1% |
| Space Separator | 9770 | 0.9% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 183182 | |
| O | 125425 | |
| A | 110863 | |
| T | 80422 | 7.2% |
| E | 78142 | 7.0% |
| B | 68574 | 6.2% |
| R | 68574 | 6.2% |
| L | 66621 | 6.0% |
| K | 56851 | 5.1% |
| Y | 56851 | 5.1% |
| Other values (8) | 215498 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2510 | |
| i | 2510 | |
| n | 1255 | |
| s | 1255 | |
| p | 1255 | |
| c | 1255 | |
| f | 1255 | |
| d | 1255 |
Space Separator
| Value | Count | Frequency (%) |
| 9770 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1123553 | |
| Common | 9770 | 0.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 183182 | |
| O | 125425 | |
| A | 110863 | |
| T | 80422 | 7.2% |
| E | 78142 | 7.0% |
| B | 68574 | 6.1% |
| R | 68574 | 6.1% |
| L | 66621 | 5.9% |
| K | 56851 | 5.1% |
| Y | 56851 | 5.1% |
| Other values (16) | 228048 |
Common
| Value | Count | Frequency (%) |
| 9770 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1133323 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 183182 | |
| O | 125425 | |
| A | 110863 | |
| T | 80422 | 7.1% |
| E | 78142 | 6.9% |
| B | 68574 | 6.1% |
| R | 68574 | 6.1% |
| L | 66621 | 5.9% |
| K | 56851 | 5.0% |
| Y | 56851 | 5.0% |
| Other values (17) | 237818 |
Vehicle Type
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 144226 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 1.1 MiB |
Taxi Company Borough
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 144226 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 1.1 MiB |
Taxi Pick Up Location
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 144226 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 1.1 MiB |
Bridge Highway Name
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 144226 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 1.1 MiB |
Bridge Highway Direction
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 144226 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 1.1 MiB |
Road Ramp
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 144226 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 1.1 MiB |
Bridge Highway Segment
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 144226 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 1.1 MiB |
Latitude
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 94142 |
|---|---|
| Distinct (%) | 66.2% |
| Missing | 2022 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.704961 |
| Minimum | 40.498966 |
|---|---|
| Maximum | 40.912275 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 40.498966 |
|---|---|
| 5-th percentile | 40.578782 |
| Q1 | 40.64221 |
| median | 40.702367 |
| Q3 | 40.76168 |
| 95-th percentile | 40.856605 |
| Maximum | 40.912275 |
| Range | 0.41330961 |
| Interquartile range (IQR) | 0.11946984 |
Descriptive statistics
| Standard deviation | 0.082641132 |
|---|---|
| Coefficient of variation (CV) | 0.0020302472 |
| Kurtosis | -0.48580506 |
| Mean | 40.704961 |
| Median Absolute Deviation (MAD) | 0.059640299 |
| Skewness | 0.18480354 |
| Sum | 5788408.3 |
| Variance | 0.0068295567 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.88562974 | 787 | 0.5% |
| 40.8431192 | 272 | 0.2% |
| 40.88637308 | 178 | 0.1% |
| 40.88575043 | 162 | 0.1% |
| 40.88530216 | 105 | 0.1% |
| 40.88057885 | 87 | 0.1% |
| 40.82903468 | 82 | 0.1% |
| 40.88318614 | 79 | 0.1% |
| 40.88837149 | 74 | 0.1% |
| 40.87708565 | 65 | < 0.1% |
| Other values (94132) | 140313 | |
| (Missing) | 2022 | 1.4% |
| Value | Count | Frequency (%) |
| 40.49896579 | 2 | |
| 40.49900071 | 1 | < 0.1% |
| 40.49905831 | 1 | < 0.1% |
| 40.49921196 | 1 | < 0.1% |
| 40.49934087 | 1 | < 0.1% |
| 40.49934905 | 3 | |
| 40.49940396 | 1 | < 0.1% |
| 40.49965278 | 1 | < 0.1% |
| 40.49985448 | 1 | < 0.1% |
| 40.49988251 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40.9122754 | 1 | |
| 40.9118747 | 2 | |
| 40.91186643 | 1 | |
| 40.91182781 | 1 | |
| 40.91158732 | 1 | |
| 40.91133076 | 1 | |
| 40.91110034 | 1 | |
| 40.911063 | 1 | |
| 40.91105749 | 1 | |
| 40.91096477 | 1 |
Longitude
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 94141 |
|---|---|
| Distinct (%) | 66.2% |
| Missing | 2022 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.939084 |
| Minimum | -74.254818 |
|---|---|
| Maximum | -73.70118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 142204 |
| Negative (%) | 98.6% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -74.254818 |
|---|---|
| 5-th percentile | -74.110275 |
| Q1 | -73.980402 |
| median | -73.949536 |
| Q3 | -73.892224 |
| 95-th percentile | -73.785378 |
| Maximum | -73.70118 |
| Range | 0.55363731 |
| Interquartile range (IQR) | 0.088177868 |
Descriptive statistics
| Standard deviation | 0.085127478 |
|---|---|
| Coefficient of variation (CV) | -0.0011513191 |
| Kurtosis | 1.3894837 |
| Mean | -73.939084 |
| Median Absolute Deviation (MAD) | 0.038408407 |
| Skewness | -0.23520793 |
| Sum | -10514434 |
| Variance | 0.0072466876 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -73.86605482 | 787 | 0.5% |
| -73.8778577 | 272 | 0.2% |
| -73.86564827 | 178 | 0.1% |
| -73.86598948 | 162 | 0.1% |
| -73.86523092 | 105 | 0.1% |
| -73.86786228 | 87 | 0.1% |
| -73.92849713 | 82 | 0.1% |
| -73.86301113 | 79 | 0.1% |
| -73.86354294 | 74 | 0.1% |
| -73.87599451 | 65 | < 0.1% |
| Other values (94131) | 140313 | |
| (Missing) | 2022 | 1.4% |
| Value | Count | Frequency (%) |
| -74.25481779 | 1 | |
| -74.25333612 | 1 | |
| -74.2531185 | 1 | |
| -74.25311504 | 1 | |
| -74.25306946 | 1 | |
| -74.25305539 | 1 | |
| -74.25250207 | 1 | |
| -74.25244803 | 1 | |
| -74.25178071 | 1 | |
| -74.25174414 | 1 |
| Value | Count | Frequency (%) |
| -73.70118048 | 1 | |
| -73.70134026 | 1 | |
| -73.7016175 | 1 | |
| -73.70162521 | 1 | |
| -73.70167632 | 1 | |
| -73.70190128 | 1 | |
| -73.70192299 | 1 | |
| -73.70192648 | 1 | |
| -73.70192983 | 1 | |
| -73.70192989 | 1 |
Location
Text
MISSING 
| Distinct | 94142 |
|---|---|
| Distinct (%) | 66.2% |
| Missing | 2022 |
| Missing (%) | 1.4% |
| Memory size | 1.1 MiB |
Length
| Max length | 40 |
|---|---|
| Median length | 39 |
| Mean length | 39.045125 |
| Min length | 25 |
Characters and Unicode
| Total characters | 5552373 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 6 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 70214 ? |
|---|---|
| Unique (%) | 49.4% |
Sample
| 1st row | (40.784677372848186, -73.94369307178569) |
|---|---|
| 2nd row | (40.826286700852854, -73.94804079135497) |
| 3rd row | (40.79577555535228, -73.93556471483194) |
| 4th row | (40.79577555535228, -73.93556471483194) |
| 5th row | (40.707904412853836, -73.95060378045339) |
| Value | Count | Frequency (%) |
| 40.88562974190851 | 787 | 0.3% |
| 73.86605482246202 | 787 | 0.3% |
| 40.843119201779096 | 272 | 0.1% |
| 73.8778577026157 | 272 | 0.1% |
| 40.88637308028402 | 178 | 0.1% |
| 73.86564826928695 | 178 | 0.1% |
| 40.8857504324131 | 162 | 0.1% |
| 73.86598948170207 | 162 | 0.1% |
| 40.885302164741034 | 105 | < 0.1% |
| 73.86523091854339 | 105 | < 0.1% |
| Other values (188273) | 281400 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 578570 | |
| 4 | 543970 | |
| 0 | 492080 | |
| 3 | 489012 | |
| 9 | 452782 | |
| 6 | 440561 | |
| 8 | 421607 | |
| 5 | 402434 | |
| 1 | 369698 | 6.7% |
| 2 | 366231 | 6.6% |
| Other values (6) | 995428 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4556945 | |
| Other Punctuation | 426612 | 7.7% |
| Open Punctuation | 142204 | 2.6% |
| Space Separator | 142204 | 2.6% |
| Dash Punctuation | 142204 | 2.6% |
| Close Punctuation | 142204 | 2.6% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 578570 | |
| 4 | 543970 | |
| 0 | 492080 | |
| 3 | 489012 | |
| 9 | 452782 | |
| 6 | 440561 | |
| 8 | 421607 | |
| 5 | 402434 | |
| 1 | 369698 | |
| 2 | 366231 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 284408 | |
| , | 142204 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 142204 |
Space Separator
| Value | Count | Frequency (%) |
| 142204 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 142204 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 142204 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5552373 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 7 | 578570 | |
| 4 | 543970 | |
| 0 | 492080 | |
| 3 | 489012 | |
| 9 | 452782 | |
| 6 | 440561 | |
| 8 | 421607 | |
| 5 | 402434 | |
| 1 | 369698 | 6.7% |
| 2 | 366231 | 6.6% |
| Other values (6) | 995428 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5552373 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7 | 578570 | |
| 4 | 543970 | |
| 0 | 492080 | |
| 3 | 489012 | |
| 9 | 452782 | |
| 6 | 440561 | |
| 8 | 421607 | |
| 5 | 402434 | |
| 1 | 369698 | 6.7% |
| 2 | 366231 | 6.6% |
| Other values (6) | 995428 |
zip_codes
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 200 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2486 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14675.147 |
| Minimum | 10090 |
|---|---|
| Maximum | 26001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 10090 |
|---|---|
| 5-th percentile | 10693 |
| Q1 | 12081 |
| median | 13826 |
| Q3 | 17212 |
| 95-th percentile | 24011 |
| Maximum | 26001 |
| Range | 15911 |
| Interquartile range (IQR) | 5131 |
Descriptive statistics
| Standard deviation | 3296.5541 |
|---|---|
| Coefficient of variation (CV) | 0.22463518 |
| Kurtosis | 1.2978498 |
| Mean | 14675.147 |
| Median Absolute Deviation (MAD) | 2102 |
| Skewness | 1.1390536 |
| Sum | 2.0800553 × 109 |
| Variance | 10867269 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13512 | 5205 | 3.6% |
| 13826 | 4400 | 3.1% |
| 17617 | 3870 | 2.7% |
| 15310 | 3555 | 2.5% |
| 11605 | 2653 | 1.8% |
| 13829 | 2550 | 1.8% |
| 13513 | 2430 | 1.7% |
| 17613 | 2249 | 1.6% |
| 12083 | 1976 | 1.4% |
| 10699 | 1919 | 1.3% |
| Other values (190) | 110933 | |
| (Missing) | 2486 | 1.7% |
| Value | Count | Frequency (%) |
| 10090 | 655 | |
| 10091 | 21 | < 0.1% |
| 10092 | 782 | |
| 10094 | 5 | < 0.1% |
| 10098 | 47 | < 0.1% |
| 10099 | 1276 | |
| 10350 | 1 | < 0.1% |
| 10351 | 1 | < 0.1% |
| 10352 | 3 | < 0.1% |
| 10354 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 26001 | 1 | < 0.1% |
| 24672 | 7 | < 0.1% |
| 24671 | 233 | 0.2% |
| 24670 | 410 | |
| 24669 | 357 | |
| 24668 | 302 | |
| 24340 | 722 | |
| 24339 | 5 | < 0.1% |
| 24338 | 214 | 0.1% |
| 24337 | 244 | 0.2% |
Community Districts
Real number (ℝ)
MISSING 
| Distinct | 68 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2034 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 34.477629 |
| Minimum | 1 |
|---|---|
| Maximum | 71 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 16 |
| median | 32 |
| Q3 | 54 |
| 95-th percentile | 69 |
| Maximum | 71 |
| Range | 70 |
| Interquartile range (IQR) | 38 |
Descriptive statistics
| Standard deviation | 21.028337 |
|---|---|
| Coefficient of variation (CV) | 0.60991251 |
| Kurtosis | -1.1976096 |
| Mean | 34.477629 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | 0.20805725 |
| Sum | 4902443 |
| Variance | 442.19096 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 32 | 9199 | 6.4% |
| 23 | 5577 | 3.9% |
| 14 | 5491 | 3.8% |
| 54 | 5025 | 3.5% |
| 15 | 4450 | 3.1% |
| 36 | 4347 | 3.0% |
| 12 | 4083 | 2.8% |
| 2 | 3939 | 2.7% |
| 68 | 3879 | 2.7% |
| 69 | 3732 | 2.6% |
| Other values (58) | 92470 |
| Value | Count | Frequency (%) |
| 1 | 2551 | |
| 2 | 3939 | |
| 4 | 2828 | |
| 5 | 2780 | |
| 6 | 490 | 0.3% |
| 7 | 1479 | 1.0% |
| 8 | 544 | 0.4% |
| 9 | 2162 | |
| 10 | 2164 | |
| 11 | 1361 | 0.9% |
| Value | Count | Frequency (%) |
| 71 | 2160 | |
| 70 | 3007 | |
| 69 | 3732 | |
| 68 | 3879 | |
| 67 | 26 | < 0.1% |
| 66 | 1723 | |
| 65 | 2170 | |
| 64 | 2 | < 0.1% |
| 63 | 2353 | |
| 62 | 2565 |
Borough Boundaries
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2034 |
| Missing (%) | 1.4% |
| Memory size | 1.1 MiB |
| 2.0 | |
|---|---|
| 3.0 | |
| 4.0 | |
| 5.0 | |
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 426576 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4.0 |
|---|---|
| 2nd row | 4.0 |
| 3rd row | 4.0 |
| 4th row | 4.0 |
| 5th row | 2.0 |
Common Values
| Value | Count | Frequency (%) |
| 2.0 | 56648 | |
| 3.0 | 33956 | |
| 4.0 | 30327 | |
| 5.0 | 11583 | 8.0% |
| 1.0 | 9678 | 6.7% |
| (Missing) | 2034 | 1.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2.0 | 56648 | |
| 3.0 | 33956 | |
| 4.0 | 30327 | |
| 5.0 | 11583 | 8.1% |
| 1.0 | 9678 | 6.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 142192 | |
| 0 | 142192 | |
| 2 | 56648 | 13.3% |
| 3 | 33956 | 8.0% |
| 4 | 30327 | 7.1% |
| 5 | 11583 | 2.7% |
| 1 | 9678 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 284384 | |
| Other Punctuation | 142192 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 142192 | |
| 2 | 56648 | 19.9% |
| 3 | 33956 | 11.9% |
| 4 | 30327 | 10.7% |
| 5 | 11583 | 4.1% |
| 1 | 9678 | 3.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 142192 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 426576 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| . | 142192 | |
| 0 | 142192 | |
| 2 | 56648 | 13.3% |
| 3 | 33956 | 8.0% |
| 4 | 30327 | 7.1% |
| 5 | 11583 | 2.7% |
| 1 | 9678 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 426576 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 142192 | |
| 0 | 142192 | |
| 2 | 56648 | 13.3% |
| 3 | 33956 | 8.0% |
| 4 | 30327 | 7.1% |
| 5 | 11583 | 2.7% |
| 1 | 9678 | 2.3% |
City Council Districts
Real number (ℝ)
MISSING 
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2034 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.669813 |
| Minimum | 1 |
|---|---|
| Maximum | 51 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 13 |
| median | 26 |
| Q3 | 38 |
| 95-th percentile | 50 |
| Maximum | 51 |
| Range | 50 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 14.956067 |
|---|---|
| Coefficient of variation (CV) | 0.58263248 |
| Kurtosis | -1.2132291 |
| Mean | 25.669813 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.14350992 |
| Sum | 3650042 |
| Variance | 223.68393 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15 | 9844 | 6.8% |
| 27 | 7205 | 5.0% |
| 10 | 5757 | 4.0% |
| 48 | 5114 | 3.5% |
| 51 | 4358 | 3.0% |
| 30 | 4342 | 3.0% |
| 41 | 4265 | 3.0% |
| 38 | 4145 | 2.9% |
| 34 | 4095 | 2.8% |
| 9 | 3930 | 2.7% |
| Other values (41) | 89137 |
| Value | Count | Frequency (%) |
| 1 | 2870 | |
| 2 | 3000 | |
| 3 | 1496 | 1.0% |
| 4 | 2518 | |
| 5 | 2627 | |
| 6 | 1485 | 1.0% |
| 7 | 2072 | 1.4% |
| 8 | 2741 | |
| 9 | 3930 | |
| 10 | 5757 |
| Value | Count | Frequency (%) |
| 51 | 4358 | |
| 50 | 3898 | |
| 49 | 3746 | |
| 48 | 5114 | |
| 47 | 1082 | 0.8% |
| 46 | 1630 | 1.1% |
| 45 | 2131 | |
| 44 | 2640 | |
| 43 | 1077 | 0.7% |
| 42 | 648 | 0.4% |
Police Precincts
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 77 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2034 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.390472 |
| Minimum | 1 |
|---|---|
| Maximum | 77 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 30 |
| median | 44 |
| Q3 | 62 |
| 95-th percentile | 75 |
| Maximum | 77 |
| Range | 76 |
| Interquartile range (IQR) | 32 |
Descriptive statistics
| Standard deviation | 21.555217 |
|---|---|
| Coefficient of variation (CV) | 0.49677306 |
| Kurtosis | -0.97813679 |
| Mean | 43.390472 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | -0.28246768 |
| Sum | 6169778 |
| Variance | 464.6274 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 36 | 9200 | 6.4% |
| 11 | 5577 | 3.9% |
| 62 | 5032 | 3.5% |
| 50 | 4237 | 2.9% |
| 39 | 3939 | 2.7% |
| 76 | 3563 | 2.5% |
| 30 | 3310 | 2.3% |
| 69 | 3299 | 2.3% |
| 72 | 2967 | 2.1% |
| 43 | 2915 | 2.0% |
| Other values (67) | 98153 |
| Value | Count | Frequency (%) |
| 1 | 1023 | |
| 2 | 761 | 0.5% |
| 3 | 1787 | |
| 4 | 645 | 0.4% |
| 5 | 2314 | |
| 6 | 1455 | |
| 7 | 1819 | |
| 8 | 549 | 0.4% |
| 9 | 1273 | |
| 10 | 2509 |
| Value | Count | Frequency (%) |
| 77 | 2484 | |
| 76 | 3563 | |
| 75 | 1797 | |
| 74 | 1834 | |
| 73 | 2169 | |
| 72 | 2967 | |
| 71 | 993 | 0.7% |
| 70 | 1583 | |
| 69 | 3299 | |
| 68 | 1751 |
| Address Type | Agency | BBL | Borough | Borough Boundaries | City | City Council Districts | Community Districts | Latitude | Longitude | Open Data Channel Type | Park Borough | Police Precincts | Resolution Description | Status | Unique Key | X Coordinate (State Plane) | Y Coordinate (State Plane) | agency_name | incident_zip | location_type | zip_codes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Address Type | 1.000 | 0.000 | 0.018 | 0.037 | 0.040 | 0.055 | 0.057 | -0.008 | 0.041 | 0.004 | 0.329 | 0.037 | -0.031 | 0.434 | 0.090 | -0.245 | 0.004 | 0.041 | 0.000 | -0.013 | 0.319 | 0.011 |
| Agency | 0.000 | 1.000 | 0.002 | 0.000 | 0.000 | 0.036 | -0.004 | 0.004 | 0.002 | 0.003 | 0.002 | 0.000 | 0.004 | 0.000 | 0.011 | -0.003 | 0.003 | 0.002 | 0.500 | 0.003 | 0.000 | 0.001 |
| BBL | 0.018 | 0.002 | 1.000 | 0.894 | 1.000 | 0.726 | -0.225 | -0.008 | -0.521 | 0.307 | 0.105 | 0.894 | 0.866 | 0.102 | 0.057 | -0.029 | 0.307 | -0.520 | 0.000 | 0.681 | 0.072 | 0.337 |
| Borough | 0.037 | 0.000 | 0.894 | 1.000 | 0.999 | 0.897 | -0.131 | 0.092 | -0.006 | 0.068 | 0.112 | 1.000 | 0.510 | 0.267 | 0.070 | 0.021 | 0.068 | -0.006 | 0.000 | 0.103 | 0.123 | -0.040 |
| Borough Boundaries | 0.040 | 0.000 | 1.000 | 0.999 | 1.000 | 0.999 | 0.089 | 0.227 | 0.869 | 0.381 | 0.098 | 0.999 | -0.542 | 0.150 | 0.070 | 0.031 | 0.380 | 0.869 | 0.000 | -0.332 | 0.087 | -0.340 |
| City | 0.055 | 0.036 | 0.726 | 0.897 | 0.999 | 1.000 | 0.018 | 0.018 | -0.010 | -0.193 | 0.148 | 0.897 | 0.124 | 0.062 | 0.084 | 0.024 | -0.193 | -0.010 | 0.036 | -0.163 | 0.097 | -0.232 |
| City Council Districts | 0.057 | -0.004 | -0.225 | -0.131 | 0.089 | 0.018 | 1.000 | 0.262 | 0.063 | 0.017 | 0.093 | 0.361 | -0.134 | 0.087 | 0.058 | -0.036 | 0.017 | 0.063 | 0.001 | 0.008 | 0.066 | 0.251 |
| Community Districts | -0.008 | 0.004 | -0.008 | 0.092 | 0.227 | 0.018 | 0.262 | 1.000 | 0.188 | 0.376 | 0.097 | 0.375 | 0.084 | 0.094 | 0.071 | -0.005 | 0.376 | 0.188 | 0.000 | 0.174 | 0.043 | 0.136 |
| Latitude | 0.041 | 0.002 | -0.521 | -0.006 | 0.869 | -0.010 | 0.063 | 0.188 | 1.000 | 0.396 | 0.100 | 0.594 | -0.338 | 0.097 | 0.062 | 0.039 | 0.395 | 1.000 | 0.000 | -0.341 | 0.088 | -0.286 |
| Longitude | 0.004 | 0.003 | 0.307 | 0.068 | 0.381 | -0.193 | 0.017 | 0.376 | 0.396 | 1.000 | 0.116 | 0.615 | 0.263 | 0.093 | 0.050 | -0.024 | 1.000 | 0.396 | 0.000 | 0.573 | 0.054 | 0.311 |
| Open Data Channel Type | 0.329 | 0.002 | 0.105 | 0.112 | 0.098 | 0.148 | 0.093 | 0.097 | 0.100 | 0.116 | 1.000 | 0.112 | 0.036 | 0.375 | 0.278 | 0.225 | -0.034 | -0.049 | 0.002 | -0.017 | 0.143 | -0.062 |
| Park Borough | 0.037 | 0.000 | 0.894 | 1.000 | 0.999 | 0.897 | 0.361 | 0.375 | 0.594 | 0.615 | 0.112 | 1.000 | 0.510 | 0.267 | 0.070 | 0.021 | 0.068 | -0.006 | 0.000 | 0.103 | 0.123 | -0.040 |
| Police Precincts | -0.031 | 0.004 | 0.866 | 0.510 | -0.542 | 0.124 | -0.134 | 0.084 | -0.338 | 0.263 | 0.036 | 0.510 | 1.000 | 0.118 | 0.082 | -0.009 | 0.264 | -0.338 | 0.000 | 0.608 | 0.085 | 0.401 |
| Resolution Description | 0.434 | 0.000 | 0.102 | 0.267 | 0.150 | 0.062 | 0.087 | 0.094 | 0.097 | 0.093 | 0.375 | 0.267 | 0.118 | 1.000 | 0.649 | -0.432 | -0.010 | 0.005 | 0.000 | -0.027 | 0.331 | 0.002 |
| Status | 0.090 | 0.011 | 0.057 | 0.070 | 0.070 | 0.084 | 0.058 | 0.071 | 0.062 | 0.050 | 0.278 | 0.070 | 0.082 | 0.649 | 1.000 | 0.380 | 0.015 | 0.034 | 0.011 | 0.002 | 0.057 | -0.014 |
| Unique Key | -0.245 | -0.003 | -0.029 | 0.021 | 0.031 | 0.024 | -0.036 | -0.005 | 0.039 | -0.024 | 0.225 | 0.021 | -0.009 | -0.432 | 0.380 | 1.000 | -0.024 | 0.039 | 0.000 | -0.037 | 0.228 | -0.042 |
| X Coordinate (State Plane) | 0.004 | 0.003 | 0.307 | 0.068 | 0.380 | -0.193 | 0.017 | 0.376 | 0.395 | 1.000 | -0.034 | 0.068 | 0.264 | -0.010 | 0.015 | -0.024 | 1.000 | 0.396 | 0.000 | 0.574 | 0.054 | 0.312 |
| Y Coordinate (State Plane) | 0.041 | 0.002 | -0.520 | -0.006 | 0.869 | -0.010 | 0.063 | 0.188 | 1.000 | 0.396 | -0.049 | -0.006 | -0.338 | 0.005 | 0.034 | 0.039 | 0.396 | 1.000 | 0.000 | -0.341 | 0.088 | -0.286 |
| agency_name | 0.000 | 0.500 | 0.000 | 0.000 | 0.000 | 0.036 | 0.001 | 0.000 | 0.000 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.011 | 0.000 | 0.000 | 0.000 | 1.000 | 0.003 | 0.000 | 0.001 |
| incident_zip | -0.013 | 0.003 | 0.681 | 0.103 | -0.332 | -0.163 | 0.008 | 0.174 | -0.341 | 0.573 | -0.017 | 0.103 | 0.608 | -0.027 | 0.002 | -0.037 | 0.574 | -0.341 | 0.003 | 1.000 | 0.052 | 0.653 |
| location_type | 0.319 | 0.000 | 0.072 | 0.123 | 0.087 | 0.097 | 0.066 | 0.043 | 0.088 | 0.054 | 0.143 | 0.123 | 0.085 | 0.331 | 0.057 | 0.228 | 0.054 | 0.088 | 0.000 | 0.052 | 1.000 | 0.029 |
| zip_codes | 0.011 | 0.001 | 0.337 | -0.040 | -0.340 | -0.232 | 0.251 | 0.136 | -0.286 | 0.311 | -0.062 | -0.040 | 0.401 | 0.002 | -0.014 | -0.042 | 0.312 | -0.286 | 0.001 | 0.653 | 0.029 | 1.000 |
| Unique Key | created_date | closed_date | Agency | agency_name | Complaint Type | Descriptor | location_type | incident_zip | Incident Address | Street Name | Cross Street 1 | Cross Street 2 | Intersection Street 1 | Intersection Street 2 | Address Type | City | Landmark | Facility Type | Status | Due Date | Resolution Description | Resolution Action Updated Date | Community Board | BBL | Borough | X Coordinate (State Plane) | Y Coordinate (State Plane) | Open Data Channel Type | Park Facility Name | Park Borough | Vehicle Type | Taxi Company Borough | Taxi Pick Up Location | Bridge Highway Name | Bridge Highway Direction | Road Ramp | Bridge Highway Segment | Latitude | Longitude | Location | zip_codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 59544918 | 11/25/2023 08:28:12 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 10029.0 | 1907 1 AVENUE | 1 AVENUE | EAST 97 STREET | EAST 99 STREET | EAST 97 STREET | EAST 99 STREET | ADDRESS | NEW YORK | 1 AVENUE | NaN | In Progress | NaN | NaN | NaN | 11 MANHATTAN | NaN | MANHATTAN | 999843.0 | 225161.0 | MOBILE | Unspecified | MANHATTAN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.784677 | -73.943693 | (40.784677372848186, -73.94369307178569) | 12426.0 | 7.0 | 4.0 | 35.0 | 14.0 |
| 1 | 59543872 | 11/25/2023 07:35:34 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 10031.0 | 526 WEST 146 STREET | WEST 146 STREET | AMSTERDAM AVENUE | BROADWAY | AMSTERDAM AVENUE | BROADWAY | ADDRESS | NEW YORK | WEST 146 STREET | NaN | In Progress | NaN | NaN | NaN | 09 MANHATTAN | 1.020778e+09 | MANHATTAN | 998630.0 | 240320.0 | UNKNOWN | Unspecified | MANHATTAN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.826287 | -73.948041 | (40.826286700852854, -73.94804079135497) | 12428.0 | 37.0 | 4.0 | 23.0 | 19.0 |
| 2 | 59549161 | 11/25/2023 06:20:15 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 10029.0 | 2252 1 AVENUE | 1 AVENUE | EAST 115 STREET | EAST 116 STREET | EAST 115 STREET | EAST 116 STREET | ADDRESS | NEW YORK | 1 AVENUE | NaN | In Progress | NaN | NaN | NaN | 11 MANHATTAN | 1.017090e+09 | MANHATTAN | 1002091.0 | 229206.0 | UNKNOWN | Unspecified | MANHATTAN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.795776 | -73.935565 | (40.79577555535228, -73.93556471483194) | 12426.0 | 7.0 | 4.0 | 35.0 | 16.0 |
| 3 | 59549163 | 11/25/2023 06:16:56 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 10029.0 | 2252 1 AVENUE | 1 AVENUE | EAST 115 STREET | EAST 116 STREET | EAST 115 STREET | EAST 116 STREET | ADDRESS | NEW YORK | 1 AVENUE | NaN | In Progress | NaN | NaN | NaN | 11 MANHATTAN | 1.017090e+09 | MANHATTAN | 1002091.0 | 229206.0 | UNKNOWN | Unspecified | MANHATTAN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.795776 | -73.935565 | (40.79577555535228, -73.93556471483194) | 12426.0 | 7.0 | 4.0 | 35.0 | 16.0 |
| 4 | 59550214 | 11/25/2023 04:53:12 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 11211.0 | 250 UNION AVENUE | UNION AVENUE | MESEROLE STREET | SCHOLES STREET | MESEROLE STREET | SCHOLES STREET | ADDRESS | BROOKLYN | UNION AVENUE | NaN | In Progress | NaN | NaN | NaN | 01 BROOKLYN | 3.030400e+09 | BROOKLYN | 997945.0 | 197189.0 | MOBILE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.707904 | -73.950604 | (40.707904412853836, -73.95060378045339) | 17213.0 | 36.0 | 2.0 | 30.0 | 56.0 |
| 5 | 59545986 | 11/25/2023 04:10:24 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 10128.0 | 121 EAST 90 STREET | EAST 90 STREET | PARK AVENUE | LEXINGTON AVENUE | PARK AVENUE | LEXINGTON AVENUE | ADDRESS | NEW YORK | EAST 90 STREET | NaN | In Progress | NaN | NaN | NaN | 08 MANHATTAN | 1.015190e+09 | MANHATTAN | 996876.0 | 224314.0 | UNKNOWN | Unspecified | MANHATTAN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.782357 | -73.954409 | (40.7823573201046, -73.9544086136535) | 10099.0 | 23.0 | 4.0 | 51.0 | 11.0 |
| 6 | 59543873 | 11/25/2023 02:00:31 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 11217.0 | 94 6 AVENUE | 6 AVENUE | ST MARKS AVENUE | PROSPECT PLACE | ST MARKS AVENUE | PROSPECT PLACE | ADDRESS | BROOKLYN | 6 AVENUE | NaN | In Progress | NaN | NaN | NaN | 06 BROOKLYN | 3.009350e+09 | BROOKLYN | 991117.0 | 186827.0 | MOBILE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.679471 | -73.975242 | (40.6794710564277, -73.97524211737513) | 17619.0 | 14.0 | 2.0 | 27.0 | 50.0 |
| 7 | 59548103 | 11/25/2023 01:59:52 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 11217.0 | 92 6 AVENUE | 6 AVENUE | ST MARKS AVENUE | PROSPECT PLACE | ST MARKS AVENUE | PROSPECT PLACE | ADDRESS | BROOKLYN | 6 AVENUE | NaN | In Progress | NaN | NaN | NaN | 06 BROOKLYN | 3.009350e+09 | BROOKLYN | 991127.0 | 186847.0 | MOBILE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.679526 | -73.975206 | (40.679525944129665, -73.97520604354887) | 17619.0 | 14.0 | 2.0 | 27.0 | 50.0 |
| 8 | 59543874 | 11/25/2023 01:29:20 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 11206.0 | GRAHAM AVENUE | GRAHAM AVENUE | GRAHAM AVENUE | MONTROSE AVENUE | GRAHAM AVENUE | MONTROSE AVENUE | INTERSECTION | NaN | NaN | NaN | In Progress | NaN | NaN | NaN | 01 BROOKLYN | NaN | BROOKLYN | 999997.0 | 196983.0 | PHONE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.707336 | -73.943203 | (40.707335577687445, -73.94320294670423) | 17213.0 | 36.0 | 2.0 | 30.0 | 56.0 |
| 9 | 59548101 | 11/25/2023 01:26:20 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 11215.0 | 437 2 STREET | 2 STREET | 6 AVENUE | 7 AVENUE | 6 AVENUE | 7 AVENUE | ADDRESS | BROOKLYN | 2 STREET | NaN | In Progress | NaN | NaN | NaN | 06 BROOKLYN | 3.009710e+09 | BROOKLYN | 989873.0 | 184080.0 | UNKNOWN | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.671932 | -73.979729 | (40.67193203834086, -73.97972945430246) | 17617.0 | 14.0 | 2.0 | 27.0 | 50.0 |
| Unique Key | created_date | closed_date | Agency | agency_name | Complaint Type | Descriptor | location_type | incident_zip | Incident Address | Street Name | Cross Street 1 | Cross Street 2 | Intersection Street 1 | Intersection Street 2 | Address Type | City | Landmark | Facility Type | Status | Due Date | Resolution Description | Resolution Action Updated Date | Community Board | BBL | Borough | X Coordinate (State Plane) | Y Coordinate (State Plane) | Open Data Channel Type | Park Facility Name | Park Borough | Vehicle Type | Taxi Company Borough | Taxi Pick Up Location | Bridge Highway Name | Bridge Highway Direction | Road Ramp | Bridge Highway Segment | Latitude | Longitude | Location | zip_codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 144216 | 32316143 | 01/02/2016 06:19:59 AM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 10028.0 | 106 EAST 85 STREET | EAST 85 STREET | PARK AVENUE | LEXINGTON AVENUE | NaN | NaN | ADDRESS | NEW YORK | NaN | NaN | Assigned | 07/02/2016 07:49:42 AM | The Department of Parks and Recreation has reviewed this request and will visit the location to investigate the condition. | 01/04/2016 08:05:13 AM | 08 MANHATTAN | 1.015130e+09 | MANHATTAN | 996101.0 | 223192.0 | OTHER | Unspecified | MANHATTAN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.779279 | -73.957209 | (40.779278800779096, -73.95720904981226) | 12425.0 | 23.0 | 4.0 | 51.0 | 11.0 |
| 144217 | 32314570 | 01/02/2016 06:19:24 AM | 01/04/2016 08:05:35 AM | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 10028.0 | 114 EAST 85 STREET | EAST 85 STREET | PARK AVENUE | LEXINGTON AVENUE | NaN | NaN | ADDRESS | NEW YORK | NaN | NaN | Closed | 06/30/2016 06:19:24 AM | The agency has declined the new tree request because the suggested location cannot be planted due to infrastructure conflicts. | 01/04/2016 08:05:35 AM | 08 MANHATTAN | 1.015130e+09 | MANHATTAN | 996159.0 | 223160.0 | OTHER | Unspecified | MANHATTAN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.779191 | -73.957000 | (40.7791908912874, -73.95699968329998) | 12425.0 | 23.0 | 4.0 | 51.0 | 11.0 |
| 144218 | 32312409 | 01/02/2016 12:14:10 AM | 01/17/2017 12:00:23 PM | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 11234.0 | 1384 EAST 49TH STREET | EAST 49TH STREET | NaN | NaN | NaN | NaN | LATLONG | BROOKLYN | NaN | NaN | Closed | 07/03/2016 12:01:57 PM | The Department of Parks and Recreation has determined that the requested location cannot receive a new tree because of conflicts with surrounding infrastructure. | 01/17/2017 12:00:23 PM | 01 BROOKLYN | NaN | BROOKLYN | 1003938.0 | 167813.0 | MOBILE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.627263 | -73.929074 | (40.62726256237021, -73.92907354860395) | 13825.0 | 5.0 | 2.0 | 26.0 | 38.0 |
| 144219 | 32311162 | 01/01/2016 08:01:18 PM | 01/04/2016 01:31:29 PM | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 11238.0 | 165 PARK PLACE | PARK PLACE | CARLTON AVENUE | VANDERBILT AVENUE | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | 06/29/2016 08:01:18 PM | The agency has declined the new tree request because the suggested location cannot be planted due to infrastructure conflicts. | 01/04/2016 01:31:29 PM | 08 BROOKLYN | 3.011580e+09 | BROOKLYN | 992053.0 | 186057.0 | PHONE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.677357 | -73.971868 | (40.67735680515911, -73.97186840914296) | 13829.0 | 16.0 | 2.0 | 48.0 | 50.0 |
| 144220 | 32312384 | 01/01/2016 07:09:47 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 11694.0 | 216 BEACH 144 STREET | BEACH 144 STREET | ROCKAWAY BEACH BOULEVARD | NEPONSIT AVENUE | NaN | NaN | ADDRESS | ROCKAWAY PARK | NaN | NaN | Assigned | 07/02/2016 08:14:38 AM | The Department of Parks and Recreation has reviewed this request and will visit the location to investigate the condition. | 01/04/2016 08:14:50 AM | 14 QUEENS | 4.163080e+09 | QUEENS | 1023054.0 | 147537.0 | OTHER | Unspecified | QUEENS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.571546 | -73.860324 | (40.57154601174077, -73.86032429911937) | 20532.0 | 51.0 | 3.0 | 41.0 | 58.0 |
| 144221 | 32311873 | 01/01/2016 03:47:13 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | NaN | 10314.0 | 41 WILD AVENUE | WILD AVENUE | NaN | NaN | NaN | NaN | LATLONG | STATEN ISLAND | NaN | NaN | Assigned | 07/05/2016 12:57:08 PM | The location has been inspected and is scheduled for planting during the fall planting season. The fall planting season runs from approximately October to December, weather permitting. | 09/12/2018 11:01:43 AM | 02 STATEN ISLAND | NaN | STATEN ISLAND | 931307.0 | 155336.0 | MOBILE | Unspecified | STATEN ISLAND | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.592880 | -74.190630 | (40.592879516752724, -74.19063024025972) | 10700.0 | 30.0 | 1.0 | 14.0 | 75.0 |
| 144222 | 32312809 | 01/01/2016 01:40:47 PM | 02/22/2016 05:49:38 PM | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 11237.0 | 311 WEIRFIELD STREET | WEIRFIELD STREET | KNICKERBOCKER AVENUE | IRVING AVENUE | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | 07/02/2016 01:29:37 PM | The Department of Parks and Recreation has determined that the requested location cannot receive a new tree because of conflicts with surrounding infrastructure. | 02/22/2016 05:49:38 PM | 04 BROOKLYN | 3.033990e+09 | BROOKLYN | 1009666.0 | 192109.0 | OTHER | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.693935 | -73.908347 | (40.6939351044285, -73.9083467368299) | 13828.0 | 42.0 | 2.0 | 37.0 | 53.0 |
| 144223 | 32311150 | 01/01/2016 01:10:22 PM | NaN | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 10011.0 | 325 WEST 21 STREET | WEST 21 STREET | 8 AVENUE | 9 AVENUE | NaN | NaN | ADDRESS | NEW YORK | NaN | NaN | Assigned | 05/27/2017 01:22:46 PM | The Department of Parks and Recreation has reviewed this request and will visit the location to investigate the condition. | 11/28/2016 01:23:27 PM | 04 MANHATTAN | 1.007450e+09 | MANHATTAN | 984158.0 | 210482.0 | OTHER | Unspecified | MANHATTAN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.744401 | -74.000332 | (40.74440106273172, -74.0003320147093) | 12074.0 | 12.0 | 4.0 | 10.0 | 6.0 |
| 144224 | 32312385 | 01/01/2016 12:40:50 PM | 03/04/2016 02:33:21 PM | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 11414.0 | 90-28 SHORE PARKWAY | SHORE PARKWAY | 90 STREET | BELT PARKWAY EXIT 17 EASTBOUND | NaN | NaN | ADDRESS | HOWARD BEACH | NaN | NaN | Closed | 07/02/2016 08:04:57 AM | The Department of Parks and Recreation has determined that the requested location cannot receive a new tree because of conflicts with surrounding infrastructure. | 03/04/2016 02:33:21 PM | 10 QUEENS | 4.114720e+09 | QUEENS | 1027695.0 | 181450.0 | OTHER | Unspecified | QUEENS | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.664608 | -73.843401 | (40.66460847040166, -73.84340074171881) | 15314.0 | 62.0 | 3.0 | 41.0 | 64.0 |
| 144225 | 32311944 | 01/01/2016 09:35:43 AM | 01/04/2016 01:29:15 PM | DPR | Department of Parks and Recreation | New Tree Request | For One Address | Street | 11223.0 | 405 AVENUE T | AVENUE T | EAST 1 STREET | EAST 2 STREET | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | 06/29/2016 09:35:43 AM | The agency has declined the new tree request because the suggested location cannot be planted due to infrastructure conflicts. | 01/04/2016 01:29:15 PM | 15 BROOKLYN | 3.071040e+09 | BROOKLYN | 992510.0 | 157735.0 | PHONE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.599619 | -73.970255 | (40.59961856018033, -73.97025549178916) | 18183.0 | 32.0 | 2.0 | 45.0 | 36.0 |